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.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
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.