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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
superhayan
Helper I
Helper I

Difference between 2 Percentage Columns in Matrix Visual

Hello all,

 

This is just a simple math question but I cannot get it correctly shown in a matrix.

 

I have 2 data tables to look at deal records of Sponsored Accounts and Non Sponsored Accounts. Both tables have the same columns: Account, Product, Status. Each record refers to 1 deal record. 

I also have a Status table that has active many:1 relationship with both data tables. 

 

I made a matrix visual on Account Level as below.
Row: Status
Values: Sponsored Count / SponsoredDeals_Percentage / Non Sponsored Count / NonSponsoredDeals_Percentage / % Difference (Sponsored % - Non Sponsored %)

The count and % are correct. However as you can the % Difference column shows wrong %. For the first row, it should be 1% instead of 350%.

superhayan_0-1729631378846.png

 

 

The DAX measures for above columns are as below. And the summarization I used for % Difference column is Sum. I tried to change the Matrix to Table then choose No Summarization but it will then splitted into 2 rows for each Status and the % difference is still wrong.

 

superhayan_1-1729631649079.png

 

Please give me a helping hand, thanks!!

1 REPLY 1
Anonymous
Not applicable

Hi @superhayan ,

 

Please provide sample data as well as your expected results.

 

Best regards,
Community Support Team_ Scott Chang

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.