Switch function

[marial16]

Hello,

i could need some help writing a switch function and creating a chart.

i want to count order numbers by Customer Group.

i created the following measures to populate a matrix table for each Group

Total CustomerGroup Pharmacy = CALCULATE(COUNTROWS(ExtraOrders),FILTER(ExtraOrders,ExtraOrders[CustomerGroup]= "Pharmacy"))

Total CustomerGroup Wholesale = CALCULATE(COUNTROWS(ExtraOrders),FILTER(ExtraOrders,ExtraOrders[CustomerGroup]= "Wholesalers"))

i have several more group names like Pharmacy and wholesale.

i would like to create a Measure for All groups by using a Switch function and then display all groups in a clustered column chart like the following.

[Arul · Accepted solution]

@marial16 ,

You can try disconnected table approach. Please check this blog.
https://www.sumproduct.com/blog/article/power-pivot-principles/ppp-variables-and-disconnected-tables... 

Thanks,