Solved: Countif DAX

Anonymous · ‎12-15-2017

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

Anonymous · ‎12-17-2017

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"
)

View solution in original post

Anonymous · ‎12-17-2017

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 · ‎12-20-2017

Thank you all for this gret answers .

v-ljerr-msft · ‎12-17-2017

Hi @Anonymous,

Just knowing the Excel formula, it will be hard for us to convert it to DAX formula which works for you. Could you post your table structures with some sample/mock data, and the expected result? So that we can better assist on this issue.

Regards