Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Example 1.

     

    The total should be $290,920

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

             Example 2

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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