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

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."

 

 

 

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago
    try this ?
     
    mokhawaja
    Value =
    SWITCH (true(),
        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

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        MAX operates on numbers, not text. For text you could use FIRSTNONBLANK or LASTNONBLANK.