Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
I could really use some help with this. I have the Matrix below
All the rows are Measures that I have created. The Prior FY % and Current FY % rows are just the same measures as Prior FY # and Current FY # but 'show as % of grand total'.
I am trying to create another Measure row called Ratio Change % that would be Current FY % - Prior FY %.
Is there a way to calculate this without having to create percetnage measures separate from the ones I already have?? Any help and guidance and in the right direction would be much appreciated!
@schmitm3 , looking at this seem like you have to create a new measure, or you can consider calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0