Forum Discussion

mokhawaja's avatar
mokhawaja
Frequent Visitor
9 years ago
Solved

If function cannot check inside a column

Hi, pretty exicted for the first post in Power BI forums :smileyvery-happy:   i am trying to create a measure based on an if function which should check inside a column called "Class" which has 3 ...
  • mokhawaja's avatar
    mokhawaja
    9 years ago

    the error is gone but it does not give me the right results (it gives me all zeros!)

     

    i re-tried the if function using measure inside the Classes table but also had to wrap it into a MAX function: and now it works perfectly 

     

    Measure =
IF (
    MAX ( Classes[Class] ) = "A", [Coverage A KPI],
    IF ( MAX ( Classes[Class] ) = "B", [Coverage B KPI],
    0 )
)

    really appreciate your time and help

     

    Best Regards,

    Mohammad

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

 

mokhawaja

 

Value =
SWITCH (
    Classes[Class],
    Classes[Class] = "A", [Coverage A KPI],
    Classes[Class] = "B", [Coverage B KPI],
    Classes[Class] = "C", [Coverage C KPI],
    0
)

 

  • mokhawaja's avatar
    mokhawaja
    Frequent Visitor
    9 years ago

    thank you vanessafvg,

    really appreciate your help... i used your suggested formula and it showed me the below error:

     

     

    kindly advise,

    Regards

    Mohammad

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      9 years ago

      mokhawajai think you have to create a new column not a new measure.

      • mokhawaja's avatar
        mokhawaja
        Frequent Visitor
        9 years ago

        Hi,

         

        i tried the column... and now it says:

         

        "Function 'SWITCH' does not support comparing values of type Text with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values."