Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.