Forum Discussion
Define aggregation at total
Hello,
You may use following formula:
KPI1% =
DIVIDE (
SUM ( Table1[Export] ) - SUM ( Table1[Import] ),
SUM ( Table1[Export] )
)KPI2% =
DIVIDE (
SUMX ( Table1, ABS ( Table1[Export] - Table1[Import] ) ),
SUM ( Table1[Export] )
)
The measures suggested by EminUZUN already define the aggregation to be used.
You have to use these measures instead of the source columns. In fact, you may even remove the columns from your model.
Thanks a lot for clarification :)
Can you please help me again? I am having issue with KPI2%. At SKU level, KPI2% and KPI1% are different although they should be the same but different at total level. Attached example and formula for KPI2%. Please advise.
This measure should return the expected results if 'Table' only contains one row per SKU.
Is it the case?
Yes.