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.
I need some help explaining this behavior. It caught me off guard and I can't seem to get my head around why its occuring.
See these two calculate metrics.
As expected, the "No Filter" test metric is repeating the value for ground on each service level.
However, if you change the default sort of service level to be off a different column, it will yield this result.
Why does using the "Sort by Column" feature change the results of this calculation? Is this expected or a potential bug?
you are using "Sort by Column" not sorting from the grid itself ?
Correct, "Sort by column" sorting based on a different column on the same dimension table