Measure for count if function

[johanbakx]

Hi all,

I am looking for a very simple measure that works exactly the same as the count if function in Excel. 

I have a column named "Justified/Non-justified" and in that column there are 2 different values: Justified and Non-justified.

I would like 2 measures; one to count the number of times "Justified" appears in that column, and the other measure must do the same for "Non-justified" .

Hoping for your help!

Regards, Johan

[Greg_Deckler · Accepted solution]

So, in general to replicate COUNT IF, you use CALCULATE with the appropriate FILTER clause.

[johanbakx]

Sorry for the late reply, but this indeed works! Thanks!