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 matrix visual that displays the following values as a hierarchy: Role, Resource, Stage, Project. The columns are Weeks, and the values are Hours.
The row values for "Resource" are conditionally formatted based on "Field Value" and based on a measure called "Utilization Rate". Utilization Rate is Calculated as:
This solution does not work. The conditional formatting is still applying to the filtered values, which I suppose makes sense given the row-level security.
Hi @kault
If you want to display the over all value despite the connected role try including your formula in a 'CALCULATE' function excluding 'ALL' applied filters on your table (Deployment or Sector)
https://learn.microsoft.com/en-us/dax/calculate-function-dax
https://learn.microsoft.com/en-us/dax/all-function-dax
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated
Thank you. I've tried to add CALCULATE and ADD in various parts of the formula and keep getting errors. Where is the appropriate place to put these?
The formula should look like this
CALCULATE(whatever you want to calculate, ALL(the table used for RLS))
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
91 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |