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.
I have created the below matrix table. One of the measures created (LISA BG/AG Ratio) was returning blank values due to the measure being unable to divide by 0. I changed the DAX to provide an alternate value of 0. It seems that the alternate values are not aggregating with the other values in the column to provide an accurate Total amount (should be 0.8 not 2.3). I imagine this requires a little more advanced DAX than I have used. DAX syntax:
Any help is appreciated.
Solved! Go to Solution.
Hi @Surveys - can you explain further why you expect the "Total" row to show 0.8 instead of 2.3? Your formula is BG/AG, which on the Total row is 25/11 = 2.3
PowerBI/DAX doesn't sum up the way Excel pivot tables do - measures are calculated in the context of the total data set - so it is acting correctly based on information you have given so far.
Hope this helps
David
Hi @Surveys - can you explain further why you expect the "Total" row to show 0.8 instead of 2.3? Your formula is BG/AG, which on the Total row is 25/11 = 2.3
PowerBI/DAX doesn't sum up the way Excel pivot tables do - measures are calculated in the context of the total data set - so it is acting correctly based on information you have given so far.
Hope this helps
David
I was looking at it the wrong way. Thanks.
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 | |
8 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
9 |