Forum Discussion
Solved
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...
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
Thank you for your reply. I have the following measure with dax- ( If[ measure 1] ,1,0). I want to create the another measure that would sum the total number of 1 for previous measure.
Eg
Measure1 = ( If[ measure] ,1,0)
Measure2 = sum(measure1)
But measure2 won't refer measure1 and I can't create a calculated column for measure1 dax due to circular dependency. Thanks
Eg
Measure1 = ( If[ measure] ,1,0)
Measure2 = sum(measure1)
But measure2 won't refer measure1 and I can't create a calculated column for measure1 dax due to circular dependency. Thanks
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
- The dax code for measure1- ( If[ measure] ,1,0). It refers to a previous measure and shows 1 if condition is true.
Hey NISH72 ,
I doubt that, as there is a syntax issue IF[measure], 1, 0) should look like IF([measure], 1, 0)
Nevertheless, try this for measure 2:
SUMX( 'table' //the table to iterate , IF([measure] ... //the condition , 1 //true , BLANK() //false ) )Regards,
Tom