Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX measure

I have created a table visual and I want to see the classification change as the slicer is being modified. For example                          Actual Utilisation rate Utilisation classificati...
  • Icey's avatar
    Icey
    4 years ago

    Hi Anonymous ,

     

    Do you mean something like this?

    Measure =
VAR Count_SelectedQuar =
    COUNTROWS ( VALUES ( 'Table'[Quarter] ) )
RETURN
    SWITCH ( Count_SelectedQuar, 1, 0.25, 2, 0.50, 3, 0.75, 1.00 )

     

    Or,

    Measure =
VAR Count_SelectedQuar =
    COUNTROWS ( VALUES ( 'Table'[Quarter] ) )
RETURN
    SWITCH ( Count_SelectedQuar, 1, "25%", 2, "50%", 3, "75%", "100%" )

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi 
Not Really.
i want the result <25% budget or >25% budget based on the quarter no. during the year.