Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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?
User | Count |
---|---|
115 | |
95 | |
87 | |
76 | |
65 |
User | Count |
---|---|
138 | |
113 | |
110 | |
98 | |
93 |