Forum Discussion
How to refer a measure in Sim function
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
Hey NISH72 ,
basically it's not clear what the measure [measure 1] will return ...
You might look into one of the table iterator functions like SUMX and create a measure like so:
SUMX(
'table' //the table to iterate
, IF([measure 1] ... //the condition
, 1 //true
, BLANK() //false
)
)If this does not help, please create a pbix that contains sample data, upload the file to onedrive or dropbox and share the link.
Don't forget to describe the expected outcome based on your sample data.
Regards,
Tom
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