Forum Discussion

Rob_B's avatar
Rob_B
Helper I
6 years ago
Solved

Filter visualizations by measure value AND column value

I need to filter my visualizations by a measure value and a column value. Visual filters appear to only allow filtering the measure by the measure value. In any case, this approach would not be ideal...
Need Help
  • Rob_B's avatar
    Rob_B
    6 years ago

    Thanks Pragati11, that's good to know!

     

    I was able to achieve the result I wanted by creating a new measure using the CALCULATE and FILTER functions with logical operators:

     

    Scenario TRC Ratio (adjusted) = CALCULATE(
'Scenario Measures'[Scenario TRC Ratio]|Filter(Forecast|Forecast[Activity]<>"B" || Forecast[Activity]="B" && 'Scenario Measures'[Scenario TRC Ratio]>=1
)
)

     

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Rob_B ,

 

To filter all the visualisations you need to have a slicer which can only be a column. You can never use a Measure in a slicer.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

Rob_B's avatar
Rob_B
Helper I
6 years ago

Thanks Pragati11, that's good to know!

 

I was able to achieve the result I wanted by creating a new measure using the CALCULATE and FILTER functions with logical operators:

 

Scenario TRC Ratio (adjusted) = CALCULATE(
'Scenario Measures'[Scenario TRC Ratio]|Filter(Forecast|Forecast[Activity]<>"B" || Forecast[Activity]="B" && 'Scenario Measures'[Scenario TRC Ratio]>=1
)
)