Count values based on failed subjects

[Sathvik123]

Hello All,

I have a table where I have data like below.

Student name and Each subject pass or fail.

Sutdent Name	Telugu	English	Hindi
Maha	P	F	F
Rama	F	P	P
Raja	F	F	F

My requirement is I need to show a filter called failed count to the user.

So If he select 1 from the filter then I need to show Rama as he failed in 1 subject

If I select 2 from the filter then I need to show Maha as he failed in 2 subjects.

If I select 3 from the filter then I need to show Raja as he failed in 3 subjects.

I am not able write the DAX calculation for this to get failed count .

Could any one please help how to write this dax calc.

[Arul · Accepted solution]

@Sathvik123 ,

try this in calculated column,

Failed Count = IF(
    'Table'[Telugu] = "F",1,0) + IF(
    'Table'[English] = "F",1,0) + IF(
    'Table'[Hindi] = "F",1,0)

I have attached the pbix file for you to refer.