Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |