Measure Not returning correct Multiplication value

[sanrajbhar]

Hi,

I have Unpivot table which generated from one big table in power query mode. I need to do multiplication using  from one column  value to selected filter value row wise if Attribute is equal to "N60". but it showing wrong value? e.g

calcDax = SUMX(Table1,IF(Table1[Attribute]="N60",Table1[Value]*SELECTEDVALUE(Factor[N95f_val]),Table1[Value]))

Thanks, S

[mahoneypat]

Do your values have replicate rows (in this case the result is 5X of the expected)?  If so, use VALUES to get a single value.

calcDax = SUMX(VALUES(Table1[Value]),CALCULATE(IF(Table1[Attribute]="N60",Table1[Value]*SELECTEDVALUE(Factor[N95f_val]),Table1[Value])))

Regards,

Pat

[sanrajbhar]

thank you very much ..! I tried on small piece of data , it seems to work good. 

I was getting single value for column error  in your above dax. I changed the code with SUM. But now problem is - This CalcDax is going to be X-axis value in Scatter Plot. Now it is showing sum which looks not correct.

Any Solution ?

e.g

calcDax = SUMX(VALUES(Table1[Value]),CALCULATE(IF(sum(Table1[Attribute])="N60",max(Table1[Value])*SELECTEDVALUE(Factor[N95f_val]),max(Table1[Value]))))

[v-kelly-msft]

Hi @sanrajbhar ,

Try the measure as below:

calcDax = IF(Table1[Attribute]="N60",Table1[Value]*SELECTEDVALUE(Factor[N95f_val]),Table1[Value])

If it doesnt work,would you pls upload your .pbix file to one drive business and share the link with us?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!