Units Market Share change per vendor selected

[alisonpappas]

Hi,

I am trying to make a line graph that compares percent units market share to percent units market share rolling 12 months and to be able to change it to compare the spcific vendor. I am believing that the result being created has the ability to compare the market share based on the comparison between vendors however it is unable to compare a selected vendor to the rest.

As you can see, once i select one vendor, the line flattens out. I believe it has something to do with the equation being able to compare all but unable to portray the selected over the unselected. The equation is as follows:

% Units market share r12m = divide([total units r12ms], calculate([total units r12ms], allexcept(data, data[csi vendor])))

How do I get this equation to be able to compare the selected over all and be able to change when I change who I select?

[Kristjan76]

Hi there,

I am not sure if this is going to help you all the way, but hopefully give you some ideas. The problem is when you select the vendor from the list you are going to filter on that vendor and only that vendor, so the rest of the vendors are not visible to the graph.

I started out by creating a calculated table:

Vendor = VALUES('Data'[CSI Vendor])

And then I created two measures, one computing the marketshare of the selected vendors and then the marketshare of the non-selected vendors.

% Selected Vendor = 
VAR _SelVendor = VALUES(Vendor[Vendor])
VAR _VendSale = CALCULATE([Total Sale]; data[CSI Vendor] IN _SelVendor)
VAR _Total = CALCULATE([Total Sale];ALL(data[CSI Vendor]))
RETURN
DIVIDE(_VendSale;_Total)

% Non Selected Vendor = 
VAR _SelVendor = VALUES(Vendor[Vendor])
VAR _VendSale = CALCULATE([Total Sale]; NOT data[CSI Vendor] IN _SelVendor)
VAR _Total = CALCULATE([Total Sale];ALL(data[CSI Vendor]))
RETURN
DIVIDE(_VendSale;_Total)

Tehn you would use the Vendor as a filter on the page from the new table, and that table would not be connected to the rest of the model.

Best regards,

Kristjan