topic Re: Convert Conditional CountIFS from Excel to DAX , help please in DAX Commands and Tips

Convert Conditional CountIFS from Excel to DAX , help please

Matt_HD — Fri, 17 Jul 2020 15:51:41 GMT

I have the following excel formula

=IF(

[@[Is Standard]]=FALSE,

COUNTIFS([Programme],[@Programme],[Framework/Standard Title],[@[Framework/Standard Title]],[Overall cohort year],[@[Overall cohort year]]),

COUNTIFS([Framework/Standard Title],[@[Framework/Standard Title]],[Overall cohort year],[@[Overall cohort year]])

)

Assume its all in one table (Table1) how do I write this as a measure?

Thanks in advance

Re: Convert Conditional CountIFS from Excel to DAX , help please

amitchandak — Fri, 17 Jul 2020 16:18:57 GMT

Matt_HD , Can you share sample data and sample output in table format?

Re: Convert Conditional CountIFS from Excel to DAX , help please

AntrikshSharma — Fri, 17 Jul 2020 16:26:25 GMT

Try something like this:

Measure = VAR FirstResult = COUNTROWS ( FILTER ( Table, Table[Programme] = "Some Condition" && Table[Framework/Standard Title] = "Some Condition" && Table[Overall cohort year] = "Some Condition" ) ) VAR SecondResult = COUNTROWS ( FILTER ( Table, Table[Framework/Standard Title] = "Some Condition" && Table[Overall cohort year] = "Some Condition" ) ) RETURN IF ( SELECTEDVALUE ( Table[Is Standard] ) = "False", FirstResult, SecondResult )