Total sum incorrect

[Anonymous]

Hi,

I have a calculated measure that I am using in Power BI, the data in the table I am displaying it in is working but the total sum is incorrect. In the past I have used the below formula to solve this but this time it is not working as I am not working with 2 x tables. I am working with 1 x table and 2 x calculated measures.

Used in the past below calculation but not working:

MeasureName = SUMX ( TableName, CALCULATE ( SUM(TableName[ColumnName1]) * SUM(TableName[ColumnName2 ]) ) )

Total Sales ($DBP) from 23/11/2018 until today - Calculation: 

([Store Qty Sold from 23/11/2018] + [Online Qty Sold from 23/11/2018])

*

SUM('Skus'[DBP])

Anyone know how to make the total show as correct?

Thanks,

Jo

[v-shex-msft]

HI @Anonymous,

Can you please share a pbix file with some sample data(test data with same data structure) and formulas so that we can test to coding formula on it?

Regards,

Xiaoxin Sheng

[Anonymous]

Example 1.

The total should be $290,920

[parry2k]

@Anonymous well not sure if it helps to understand the problem. If you can shre sample data with relationship of tables that will help to provide the solution.

[Anonymous]

     Example 2

[parry2k]

@Anonymous can you share the sample data and expected result. Hope this article helps to post your question.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490