Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!
@Anonymous , 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