Countif DAX

[Anonymous]

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 · Accepted solution]

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]

Thank you all for this gret answers . 

[v-ljerr-msft]

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