Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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%.
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.
Please give me a helping hand, thanks!!
Hi @superhayan ,
Please provide sample data as well as your expected results.
Best regards,
Community Support Team_ Scott Chang
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |