Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

% calculation at subtotal level and difference calculation



I need to see the subtotals at subtype-region level and calculate their difference vs one particular region. How do I do that?
All the columns below from W onwards are measures 




Community Support
Community Support

Hi @FAA9 


Can you please paste some dummy data and measure formula of X & Z? In addition, where do you want to display the Diff % value (96-83)?


Best Regards,
Community Support Team _ Jing


X & Z are basically being calculated at row level (lowest granularity) based on prior weeks data & summing up of inventories at different warehouses. They are a combination of other measures.
I wish to be able to see the diff value in the table on the right. 
I was able to use the pivot table calculation of show "difference vs Region" for Z vs X measure to show the difference by using UK as the base region, however, that difference is only visible if I have UK in the table and UK field is expanded. 
I want to be able to show that difference even if UK is not part of the selection at type and subtype level.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors