Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Countif DAX

Hi i would like to convert this formula in Excel to Dax  =IF(D2=D1,"",IF(COUNTIF(AH2:AH14,"YES")+COUNTIF(AH2:AH14,"N/A")<13,"NO","YES"))   thanks a lot 
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    As v-ljerr-msft said, this will be difficult based on what you have shown here.  DAX is more column named based.  Sounds like you are after a measure though.  My best guess would be something that looks like this, which assumes you want it to be context sensitive:

    YourMeasure = IF(
	CALCULATE(
		countrows('YourTable'),		
		OR(
			'YourTable'[AHColumnsName] = "YES",
			'YourTable'[AHColumnsName] = "N/A"
		)
	) < 13,
	"NO",
	"YES"
)

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

As v-ljerr-msft said, this will be difficult based on what you have shown here.  DAX is more column named based.  Sounds like you are after a measure though.  My best guess would be something that looks like this, which assumes you want it to be context sensitive:

YourMeasure = IF(
	CALCULATE(
		countrows('YourTable'),		
		OR(
			'YourTable'[AHColumnsName] = "YES",
			'YourTable'[AHColumnsName] = "N/A"
		)
	) < 13,
	"NO",
	"YES"
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you all for this gret answers .