I am using CPG data and need help comparing a companies sales data to their competition. In the sample data you will see 4 unique entries for "Company", Acme, Acme Competition, Smart Div and Smart Div Competition. In this example I want to compare the sales for Acme against the sales for Acme Competition. Ideally I would have my user select a slicer for Acme (not Acme Competition) and display both the data for Acme & Acme Competition.
Acme Div will ALWAYS be compared to Acme Competition such as Smart Div will ALWAYS be compared to Smart Competition. Additionally both Acme and Smart are under the same umbrella so our user may select both Acme and Smart. That means that the aggregation of Acme Div and Smart Div would need to be compared to the aggregation of Acme Competition and Smart Competition. My initial thought was to create a lookup table and have Acme as a parent company so that when I select Acme I can see both companies.
I am trying to stay away from hard coding companies, such as a measure like, Acme Competition Sales:= CALCULATE( [Sales] , data[Company] = "Acme Competition" ). I am also trying to stay away from cubes.
Hope this was *somewhat* clear.
Thanks
Acme Div will ALWAYS be compared to Acme Competition such as Smart Div will ALWAYS be compared to Smart Competition. Additionally both Acme and Smart are under the same umbrella so our user may select both Acme and Smart. That means that the aggregation of Acme Div and Smart Div would need to be compared to the aggregation of Acme Competition and Smart Competition. My initial thought was to create a lookup table and have Acme as a parent company so that when I select Acme I can see both companies.
I am trying to stay away from hard coding companies, such as a measure like, Acme Competition Sales:= CALCULATE( [Sales] , data[Company] = "Acme Competition" ). I am also trying to stay away from cubes.
Hope this was *somewhat* clear.
Thanks
