Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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!
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?
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 47 | |
| 36 | |
| 27 | |
| 15 | |
| 15 |
| User | Count |
|---|---|
| 58 | |
| 56 | |
| 38 | |
| 21 | |
| 21 |