Reply
Highlighted
Frequent Visitor
Posts: 10
Registered: ‎08-25-2016
Accepted Solution

Wrong Sum totals when using a SUM measure from two different Tables

Dear All PBI Users, 

 

I am getting the wrong columnb totals when i create a measure between two different tables. See Attached picture. How do i solve this. 

 

The formula i have used in shown in the formula bar. 

 

Kindly this is urgent if someone could assist at the soonest 

 

ThanksWrong Sum totals when using a SUM measure from two different Tables.jpg


Accepted Solutions
Regular Visitor
Posts: 33
Registered: ‎03-14-2017

Re: Wrong Sum totals when using a SUM measure from two different Tables

Hi @Patelnitya

 

Please use the following DAX :

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

 

This should work...

 

Thanks,

Himanshu

View solution in original post


All Replies
Regular Visitor
Posts: 33
Registered: ‎03-14-2017

Re: Wrong Sum totals when using a SUM measure from two different Tables

Hi @Patelnitya

 

Please use the following DAX :

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

 

This should work...

 

Thanks,

Himanshu

Frequent Visitor
Posts: 10
Registered: ‎08-25-2016

Re: Wrong Sum totals when using a SUM measure from two different Tables

This works perfect. 

 

Thanks Himanshu.