Forum Discussion
Create Measure From Virtual Table
well, you can t use summarizecolumns in measure
try using addccolumns ( summarize ( .. ) instead .
and for the return, just return aggregation without the { } .
the { } were only needed for the query not to be used in the measure.
hope this makes sense.
because it is returning a scalar value, you cant use it like this when authoring a dax query
to be able to see it in the query editor,, write the evaluate like this :
evaluate { _aggtable }
It worked in DAX editor , but not when I went to set up the measure in the visualization page. Any other changes necessary to make this scalar work in a measure?
DAX editor result:
Measure Code:
well, you can t use summarizecolumns in measure
try using addccolumns ( summarize ( .. ) instead .
and for the return, just return aggregation without the { } .
the { } were only needed for the query not to be used in the measure.
hope this makes sense.
This worked Daniel. Thank you!