Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ShawnR2424
Frequent Visitor

Filtering a Measure with another Measure

I have a simple scorecard that is showing the output of a measure (Feature Active Users).  This measure is taking a user table and filtering (depending on feature use frequency) for only active users. When I go to "Filters on this visual", I can't really add a measure to filter this value by. My goal was to filter by another measure (Unique Features Used) that calculates the distinct # of features used (feature use intensity), and filter feature active users by only a single feature being used. Why can't I do this?

 

I know I can kind of combine both measures logic into a new measure, but is that the only solution? My report has a lot of measures already, so I was hoping to avoid creating more. Any advice is appreciated.

Thanks!

2 REPLIES 2
Bifinity_75
Solution Sage
Solution Sage

Hi @ShawnR2424 , to optimize the number and use of the measures I advise you to use VAR:

VAR keyword (DAX) - DAX | Microsoft Learn

Best regards

I am using variables, but my main question is can you filter a measure with another measure?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!