topic Re: Wrong Sum totals when using a SUM measure from two different Tables in DAX Commands and Tips

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

Patelnitya — Wed, 15 Mar 2017 08:11:54 GMT

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

Thanks

himanshu56 — Wed, 29 Mar 2017 05:58:45 GMT

Please use the following DAX :

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

This should work...

Thanks,

Himanshu

Patelnitya — Wed, 29 Mar 2017 15:38:54 GMT

This works perfect.

Thanks Himanshu.