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.
Thanks for the response!
Your solution does help to return a single row and column, which is the closest I've come so far. However it does not appear it is a pure scalar value because I cannot throw it in a card to display the single value on my dashboard.
Is it possible to run one of the aggregator functions over to entire result of the second virtual table?
Thank you,
Matt
you can use maxx or minx if you are sure that you have 1 value . or you have multiple values all the same. mmahoney045