Forum Discussion

NISH72's avatar
NISH72
Helper IV
6 years ago
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...
Need Help
Show and Tell
  • TomMartens's avatar
    TomMartens
    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

NISH72's avatar
NISH72
Helper IV
6 years ago
The dax code for measure1- ( If[ measure] ,1,0). It refers to a previous measure and shows 1 if condition is true.
TomMartens's avatar
TomMartens
Super User
6 years ago

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