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

     

3 Replies

  • 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 . 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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. :smileyhappy:

     

    Regards