Forum Discussion
DAX Formula Help
Scenario: I work for a CPG company that is building out our BI dashboards. One thing we like to look at is our performance in a given retailer compared to that retailer's rest of market (ROM). I'm tr...
It's not clear (at least to me) from your example what data you are starting with.
Normally you would calculate the 2 values you want to compare and store them in VARs
Then do the division using the 2 VARs
That also allows you to return each var independantly in order to debug your progress
Performance Against ROM =
VAR ourperformance = ..some calculation
VAR ROM = ...som calculation
RETURN DIVIDE(ourperformance,ROM)