Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Count values based on failed subjects

Hello All,

 

I have a table where I have data like below.

Student name and Each subject pass or fail.

 

Sutdent NameTeluguEnglishHindi
MahaPFF
RamaFPP
RajaFFF

 

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.

 

Need Help
  • Arul's avatar
    Arul
    2 years ago

    Anonymous ,

    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.

1 Reply

  • Arul's avatar
    Arul
    Super User
    2 years ago

    Anonymous ,

    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.