'Trying to get correct grand totals for my measures
I'm calculating margin impact and the grand total is not the sum of the column. Below is the calculation measure: =([CY_MARGIN]-[PY_MARGIN])*SUM(CYPY[CY_VOL])
I've tried adding sumx(values( to the calculation but I'm still not getting the correct column sum..
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|