Wrong Totals with SUMX Measure

[likhithar]

I have  two Fact Tables Sales,Cost I will be creating 
 Total =Calculate(Sum(Sales[Sales])+SUM(Cost[Cost]]),FILTER(ALL(Calendar),Calendar[YYYYMM]<=MAX(Calendar[YYYYMM]))

Fact Tables are related to VEHICLE and VEHICLE TYPE TABLES based on V-YYYYMM and VT-YYYYMM

Vehicle and Vehicle Type in Fact Tables are derived based on RELATED DAX

V-VT(In fact Tables) is Concatenation of Vehicle and Vehicle Type 

For "Total" Measure,Rate should be multiplied

I tried the Following Measures,

The selected month rate should be multiplied with Total 

Rate Applied Total = (SUMX(VALUES(Secutirised[V-VT]),SUM(Secutirised[Rate])/100*[Total])*[Months Passed])/12(It is showing Correct Values, But Total is showing wrong)

Rate Applied Total_1 =(SUMX(VALUES(Secutirised[V-VT]),SUM(Secutirised[Rate])/100*[Total])*[Months Passed])/12

(With this measure the vales are showing wrong slightly, total is showing correct for the wrong vales)

I tried with the below sample data ,it was showing correct output.

But with the Original Data it showing wrong results.

All are measures only

TIA

[MFelix · Accepted solution]

Hi @likhithar ,

Try to make the following measure:

Final Rate value = IF(HASONEVALUE(Table[COLUMN USED ON LINE]), [Rate Applied Total], SUMX(VALUES(Table[COLUMN USED ON LINE]),[Rate Applied Total] )

You should use the column that you are using on the matrix in the formula above, then use this measure instead of the final rate value.