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:
Anyone know how to make the total show as correct?
@PowerBILeaner can you share the sample data and expected result. Hope this article helps to post your question.
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?