Skip to article

PROLOGIKA INSIGHTS

Projecting a Scalar Value with DAX EVALUATE Queries

Back to all articles

When you work on more complicated DAX measures, you should get out of the Power Pivot or BISM design environment and use the excellent DAXStudio (or SSMS) with the EVALUATE query syntax. But then eventually the measure would return a scalar value while EVALUATE requires a table. You can use the DAX ROW function to create a single-row, single-column table, and then show the result using EVALUATE.

030415_1409_Projectinga1

JOIN THE CONVERSATION

Discussion

Leave a comment

Your email address will not be published. Required fields are marked *