Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am displaying a table below on my report:
The rows are measures calculated from Table T1. The measure used to calculate the bottom row is:
Solved! Go to Solution.
Hi
I'm guessing you could replace the 'ALL(T1)' statement in your measure calculation with the ALLEXCEPT function. As stated in the documentiation (ALLEXCEPT function (DAX) - DAX | Microsoft Learn), this "Removes all context filters in the table except filters that have been applied to the specified columns".
So if you replace ALL(T1) with something like ALLEXCEPT(T1, T1[userid]), that would probably do the trick.
Best regards,
Sebastian
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
I'm guessing you could replace the 'ALL(T1)' statement in your measure calculation with the ALLEXCEPT function. As stated in the documentiation (ALLEXCEPT function (DAX) - DAX | Microsoft Learn), this "Removes all context filters in the table except filters that have been applied to the specified columns".
So if you replace ALL(T1) with something like ALLEXCEPT(T1, T1[userid]), that would probably do the trick.
Best regards,
Sebastian
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
After some further digging, I discovered that my slicer was user T1[username], not T1[userid]. I added T1[username] in the ALLEXCEPT columns and it worked!
My final query was:
Hi Sebastian,
Thanks for your response. I modified the query to:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
80 | |
72 |