Forum Discussion
Gross Margin Calculation
Hi I am trying to calculate the Gross Margin of Revenue / Non Revenue line items, my formula is below however it is not producing the desired result, hoping someone can help. Gross Margin = DIVID...
Try using ALL() in your filter statement;
DIVIDE(sum('Fact'[Actual]),CALCULATE(sum('Fact'[Actual]), FILTER(ALL('Grouping'),'Grouping'[DBC_Grouping] = "Rental Revenue")),BLANK())Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
JarroVGIT
Resident Rockstar
Resident RockstarTry using ALL() in your filter statement;
DIVIDE(
sum('Fact'[Actual])
,CALCULATE(sum('Fact'[Actual]), FILTER(ALL('Grouping'),'Grouping'[DBC_Grouping] = "Rental Revenue"))
,BLANK()
)
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
JarroVGIT Brilliant!!! Thank you for that.