Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a two columns
Value := Sum([Value of Product])
Percentage := Sum([Percentage])
Then I make the following calculation:
Total_value [Value] / [Percentage]
Or
Divide(Value, Percentage,0)
In both cases when I drag and drop it to the pivot table in Excel the following happens:
1. The calculation per line items are correct
2. When collapsing it my let’s region it seems to take the total sum of the column Value and divide by the total sum of the column
Percentage rather than divide the value by the percentage of each line and sum the results by region.
What am I doing wrong?
Thanks,
Nav
Create a new column (best in Power Query) where you'll calculate the ratio. Then bring this column into the DAX table and your measure will just sum up the values in the column.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |