Forum Discussion

Newbie22's avatar
Newbie22
Resolver I
3 years ago
Solved

Create Conditional Formatting based on Target and Minimum Target

Hi Everyone,

 

I'd like to ask for your help. I have data with different targets per SLA. Minimum column is also target but it's the minimum % an SLA must have.

 

I created a measure that I will use to create an icon (using conditional format) to determine if the SLA Summary results met the target or not. 

 

_ConditionSLATarget =
MAXX('Monthly Summary',
IF('Monthly Summary'[_SLA Summary Results] >= 'Monthly Summary'[Target],1,
IF('Monthly Summary'[_SLA Summary Results] >= 'Monthly Summary'[Minimum],0,
IF('Monthly Summary'[_SLA Summary Results] < 'Monthly Summary'[Minimum],-1))))
-----------------------------------------------------------------------------------------------------
 
My Table is: 'Monthly Summary'
SLA measure is _SLA Summary Results 
DAX Formula for _SLA Summary Results below:
_SLA Summary Results = SUM('Monthly Summary'[Met])/SUM('Monthly Summary'[Volume])
 
However, there's something strange when I put it in a table. If you notice, DAT 1 SLA should be "-1" with a downward arrow because SLA Summary result of 85.32% did not meet the minimum target of 96%
 
I don't know what went wrong so I'd like to ask for your expertise on this matter. Let me know if you need additional info. Thank you

 

 

 

 

Here's a screenshot of my conditional format for the icons in case you need.

 

 

 

 

Need Help
Tutorial Requests
  • Newbie22's avatar
    Newbie22
    3 years ago

    Thank you. 

     

    I already got the solution and It worked ğŸ˜Š

     

    Here it is:

     

    _ConditionSLATarget =
    SWITCH(
    TRUE(),
    [_SLA Summary Results] >= [Target],1,
    [_SLA Summary Results] >= [_Minimum],0,
    [_SLA Summary Results] < [_Minimum],-1)

3 Replies

  • Newbie22's avatar
    Newbie22
    Resolver I
    3 years ago

    Please don't hesitate to message me if you need additional information ğŸ¤—

    • amitchandak's avatar
      amitchandak
      Super User
      3 years ago

      Newbie22 , Make sure the above is created using measure and you are creating a measure

       

      like

      [_SLA Summary Results] >[Average of Target]

      • Newbie22's avatar
        Newbie22
        Resolver I
        3 years ago

        Thank you. 

         

        I already got the solution and It worked ğŸ˜Š

         

        Here it is:

         

        _ConditionSLATarget =
        SWITCH(
        TRUE(),
        [_SLA Summary Results] >= [Target],1,
        [_SLA Summary Results] >= [_Minimum],0,
        [_SLA Summary Results] < [_Minimum],-1)