Dynamic Clustered Column Chart

Dear Community,

in my project, I try to compare the cost structure of a product portfolio. There are 30 products in my portfolio (Prod. 1,..., 30), each of them belongs to a certain product category (fruit, vegetables, drinks, others). The production of each product involves four different types of cost (Cost A, B, C, D).

In the end, my aim is to generate a clustered column chart, with the four cost types on the X axis and a comparison of product cost, cost of category and total costs in each column-cluster:

The product is selected with a slicer:

My simple data model looks like this:

Cost per product, per category and for all products are defined as measures:

Cost_A = SUMX(COST,COST[Cost A])

Cost_A_Category = CALCULATE([COST_A], ALLEXCEPT(Categories,Categories[Product Category]))

Cost_A_All = CALCULATE([COST_A], ALL(Categories[Product Category],Categories[Product ID]))

 

Now I have 12 different measures. I can put all twelve next to each other in a graph, but I need them to be clustered by cost type. How can I do this?

 

One idea I had, was to generate a table/matrix with cost type in the first column and the names of the different measures in the columns for product/category/all comparison. But how do I get the measures working in the visual?

 

 

Anyl help of idea is highly appreciated!!

Thanks!