BI Table of DAX measure shows incorrect total

[Garbo62]

Hi I have a DAX measure that multiplies 2 values together
CapacitySum = MAX(BI_Location_Building_Data[Capacity])*SUM(BI_SurveyData[Utilised])
The individual rows calculates correctly
But the Total in the Power BI table is incorrect, how do I get the total to sum the column and not use the measure, see attached image

[Anonymous]

Hi @Garbo62 ,

I think it has something to do with your data model, try using calculated columns which will fetch data statically to some extent.

Column = [Capacity]*[Meetings]

Please feel free to correct me and provide more information if I have misunderstood you!

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[adnyk]

Hi @Garbo62 

There are many articles about "wrong" totals in tables, maybe this article from Greg_Deckler can help you:
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/633...

or this article from sqlbi:
https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/

Good luck