Forum Discussion

SeungLee95's avatar
SeungLee95
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago
Solved

Use a calculated measure from a different Table/Matrix as a slicer

Hello,   I have the following Matrix where it'll show different LiveRates depending on the LiveCount and UnitCount of each of it rows:     As it can be seen the Live Rate is simply c...
Need Help
Tips and Tricks
Tutorial Requests
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi SeungLee95 
    Sorry for the late response.
    You cannot directly use a measure in a slicer since slicers only work with columns. To achieve filtering by LiveRate in a slicer, create a calculated column instead of using a measure. For example:
    LiveRateColumn = DIVIDE([LiveCount], [UnitCount], 0)

    This column can then be used in a numeric range slicer to filter rows between values like 0.33 to 1.0. You can still keep your original LiveRate measure for conditional formatting and display in the matrix. The column is only used for slicer-based filtering.

    Best Regards,
    Cheri Srikanth

SeungLee95's avatar
SeungLee95
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago

Hi Jihwan_Kim ,

 

Thank you for the response.

 

I've tried using the numeric range parameter but fail to actually apply it.

 

The problem I believe is I can't apply a parameter since the table values are not really measures, but columns with a count

 

Is there any other suggestions you would give me?