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 Name Telugu English Hindi Maha P F F Rama F P P Raja F F F...
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.

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.