March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
125 | |
85 | |
69 | |
54 | |
45 |
User | Count |
---|---|
204 | |
105 | |
98 | |
65 | |
54 |