Forum Discussion
Using RELATED based on multiple columns
Hi, I'm trying to calculate a number bases on different percentages per category. I just can't figure out how to do this properly. Let me explain via an example. There is certain Amount per G...
HI Anonymous
Ok, try this measure
Total 2= SUMX('Table 1',[Amount]*CALCULATE(SUM('Table 2'[Percentage])))Result:
and here is sample pbix file, please try it.
Regards,
Lin
v-lili6-msft
Community Support
Community Supporthi Anonymous
In fact, the total for measure[Total] is 1203.7 not 2400.5
and for total measure, I would suggest you use this formula
Total = SUMX(Table2,[Percentage]*RELATED(Table1[Amount]))
Regards,
Lin