Forum Discussion
DAX Incorrect Grand Totals in Table
Looking for help with a DAX measurement that will provide the correct grand total;
Scenarion below;
Here is the relationship
Dimension
UniqueID
| ABC010 |
| CBE010 |
| ERB010 |
Measurements:
Table2 = [TTL Volume]*[sum of cst]
TTL Volume = SUM(Table1[Volume])
sum of cst = SUM(Table2[Cst/Unit])
Table 1
UniqueID Volume
| ABC010 | 500 |
| CBE010 | 450 |
| ERB010 | 150 |
Table 2
UniqueID Cst/Unit
| ABC010 | 150 |
Desired results would be a measurement that will give me the correct grand total of 75000.