Forum Discussion
NISH72
6 years agoHelper IV
How to refer a measure in Sim function
Hi I have the following measure with formula - ( If[ measure 1] ,1,0). I want to sum the total number of '1' for this measure. But when I create a measure with sum function ,it is not showing the foll...
- 6 years ago
Hey NISH72 ,
this does not clarify the potential outcome of [measure 1], provide the DAX code for [mesure 1].
I still assume that using SUMX() will be part of the solution.
Regards,
Tom
Greg_Deckler
6 years agoCommunity Champion
SUM works with columns. The question is, sum this measure over what? This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149