Gauge visual is showing average, not sum

[NoordenNL076]

Hello,

I'm trying to visualize the sum of maximum needed space over all products in comparison to the maximum capacity. The visual is showing the maximum capacity correctly, but not the sum of needed space over all products. Here is my formula:

Max. vol. over period m3 = AVERAGEX('Dimensions per material', 'Dimensions per material'[Volume in m3]*'Calculations'[New Max QTY])

I prefer not to change the measure itself. As you can see in the image below. It shows the average of 0.16 m3, instead of the sum (which should be around 2.3k).

Anyone have a solution to the problem?

Thanks!

[Anonymous]

Hi  @NoordenNL076 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous]

Hi @NoordenNL076 ,

Please try to create new measure as below and put this new measure onto the gauge visual. Later check if it can return the correct result...

Measure =
SUMX (
    VALUES ( 'Dimensions per material'[Product] ),
    [Max. vol. over period m3 ]
)

In addition, you can refer the method in the following links to handle with incorrect total values on the matrix visual...

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards