Dynamic grouping using dax

[Jos13]

Hi all,

I have the following tables;

Product

Orders

Support table

Total Sales = SUMX('Order','Order'[Quantity]*RELATED('Product'[price]))

I want to group products based on sales, so I created the following measure.

Measure = CALCULATE([Total Sales],

FILTER(VALUES('Product'[pname]),

[Total Sales]>MIN(grouptab[Min])

&& [Total Sales]<=MAX(grouptab[Max])

)

)

It works as expected when used with product name.

When I used this measure with date column(calendar table), it gives wrong result (column totals are wrong.

I wanted to know the contribution of each product group on a daily basis. What are the changes that I need to do in the formula to work as expected.

Link to pbix https://drive.google.com/file/d/1A817Q-I89-SskhZtK-YRWX7KNBeGk9iy/view?usp=sharing

Please help

[Jihwan_Kim · Accepted solution]

Link to the sample pbix file