Forum Discussion
Solved
Distinctcount with sum filter
Hello everyone, I need your help with the following problem. In the table below I would like to create a measure that gives me a separate count when the sum of the number column is less than 20....
For your information, I succeeded in doing this:
VAR __tmpTable = SUMMARIZE(Table,Table[Name] ,"__Brands",SUM(Table[Quantity]))RETURN CALCULATE(DISTINCTCOUNT(Table[Name]), FILTER(__tmpTable, [__Brands]<20))
For your information, I succeeded in doing this:
VAR __tmpTable = SUMMARIZE(Table,Table[Name] ,"__Brands",SUM(Table[Quantity]))
RETURN CALCULATE(DISTINCTCOUNT(Table[Name]), FILTER(__tmpTable, [__Brands]<20))