Forum Discussion

BobbyDollar's avatar
BobbyDollar
Frequent Visitor
6 years ago

Measures in Pivot

Hi I use PowerPivot in Excel and am stuck with an issue. Because i am not sure with my DAX approach I post here, hoping somebody can help. Sample date in DataModel:   Scenario Product Ye...
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
6 years ago

I would create 3 measures

FC1:= CALCULATE(SUM(Table[Volume];Scenario="FC1")
FC2:= CALCULATE(SUM(Table[Volume];Scenario="FC2")
FC2 vs. FC1:= DIVIDE([FC2];[FC1])

I'd also recommend using the DIVIDE for comparison , as it has DIV/0 handling