Forum Discussion
Solved
Grouping values from measures
Hi, I have a table that looks something like this: AccountID UserID Visits Help requests abc 111 5 0 abc 456 0 1 abc 789 15 2 def 555 2 2 def 666 0 1 ...
You should be able to do it like this:
Table = SUMMARIZE('TABLE','TABLE'[Column],"MyMeasure",[Measure])
Hi Greg_Deckler,
Thank you for such a quick reply :)
When I try with SUMMARIZE I don't have an option to do it on the basis of a Measure - it looks like it is only available for table columns.
You should be able to do it like this:
Table = SUMMARIZE('TABLE','TABLE'[Column],"MyMeasure",[Measure])Thank you so much, that's brilliant :)
When i'm creating the table, is it possible to add a filter inso that it only calculates the score where, say, the Visits column is > 5?
Sure can:
Table = FILTER(SUMMARIZE('TABLE','TABLE'[Column],"MyMeasure",[Measure]),<filter expression>)Is "Visits" your equivalent of "MyMeasure"?
If so, then it would be:
Table = FILTER(SUMMARIZE('TABLE','TABLE'[Column],"MyMeasure",[Measure]),[MyMeasure]=5)Hi Greg_Deckler
I have the same issue only difference is my filter will be selected by user from a slicer. How to do this now ?
Thanks Derek. I had similar issue and your response was helpful.
Cheers - sharan
