Forum Discussion
Solved
Group values based on another table
Hi all, I have a table with a list of salaries (Table A.), and another table with the categories I'd like to add (Table B.) Table A. Idperson Salary 57927 14 669,47 € 63584 10 61...
Hi AFra
The two articles below will explain the solution to your requirement.
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Thanks Mariusz , it works nicely : )
Car revenus ménage = CALCULATE(
VALUES('cat revenus'[Rev ménage (groups)]) ;
FILTER('cat revenus';
data[Rev ménage]>='cat revenus'[MinVal]
&& data[Rev ménage] < 'cat revenus'[MaxVal]
)
)