Dynamic Grouping on aggregated Transaction level Data

[Anonymous]

I have a table that looks like this 

The goal is to dynamically group the sum of the total sales and costs for each product name into High (>35), Medium(31-35), low(<=30).  I applied the dax pattern shown here https://www.daxpatterns.com/dynamic-segmentation/ and it worked well enough to group the total sales and costs for each product into those categories. However, To take this further I'll like to be able to show the distribution of costs for the different groups. So if I clicked on High sales group on the total sales by group visual, it should filter my total cost by group visual to show that distribution. The issue i run into is that the methodology for dynamic grouping uses a support table. As a result, Clicking the high cost category just shows me the high sales category if I have the same support table and does not do anything if i use a different support table from that of the Total cost by category visual. What would be the best way to achive this dynamic grouping with cross filtering capabilities? @Greg_Deckler @Mariusz 

Thanks! 

[Mariusz]

Hi @Anonymous 

Would you be able to demonstrate the desired visually, like excel or something?

Thanks 

Mariusz

[Anonymous · Accepted solution]

Thanks for the respose @Mariusz . I actually figured out a solution to this problem. I ended up using 2 support tables to dynamically group the total sales and cost and for each product. I then used an IF statement to filter the visuals correctly, depending on whether I wanted to see a cost distribution for a total sales group or a sales distribution for a total cost group.