Forum Discussion
Solved
Dynamic grouping using dax
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
