Skip to main content
cancel
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.

Reply
FAA9
Frequent Visitor

% calculation at subtotal level and difference calculation

Hi,

 

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 

 

FAA9_0-1663051174131.png

 

2 REPLIES 2
v-jingzhang
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

Hi,

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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors