The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I'm going around in circles to the point where I can't see the wood for the trees now.
I have a simple table:
and my objective is to identify any part that has more than one resource, then that part needs to have either a different cost or a different priority or both a different cost and priority. [Green highlights].
If a part has more than one resource and the costs and the priorities are the same, then this needs to be flagged as an error.
The table result should show me:
The measure I have is:
Now, I know the measure is recalculates at the row level but I can't think how to resolve.
Appreciate any help/guidance
Thanks
Solved! Go to Solution.
In your measure you need to explicitly remove the Resource filter.
In your measure you need to explicitly remove the Resource filter.