cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBILeaner Frequent Visitor
Frequent Visitor

Total sum incorrect

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

 

5 REPLIES 5
Super User
Super User

Re: Total sum incorrect

@PowerBILeaner 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




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






PowerBILeaner Frequent Visitor
Frequent Visitor

Re: Total sum incorrect

example total sum incorrect.jpg

Example 1.

 

The total should be $290,920

Super User
Super User

Re: Total sum incorrect

@PowerBILeaner 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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






PowerBILeaner Frequent Visitor
Frequent Visitor

Re: Total sum incorrect

     Example 2

 

Examples Power BI.jpg

 

Community Support Team
Community Support Team

Re: Total sum incorrect

HI @PowerBILeaner,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |