Group values based on another table

[AFra]

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 616,88 €
63581	20 584,60 €
48460	10 712,40 €
56542	10 712,38 €
48460	15 550,85 €
80609	13 297,22 €
80609	11 617,99 €
43517	16 938,55 €
43517	22 256,46 €
45450	6 477,12 €
43517	13 533,18 €
43517	12 139,92 €
43517	15 365,90 €
98722	10 408,80 €
98722	10 712,40 €
96768	16 263,52 €
98451	13 993,00 €
101037	10 617,36 €
99318	13 261,92 €
96771	16 720,08 €
96771	14 348,54 €
96771	15 082,08 €

Table B. 

Rev ménage (groups)	MinVal	MaxVal	ORDRE
< 5.000 €	-1000	4999,9999	1
5.000 - 10.000 €	5000	9999,9999	2
10.000 - 12.500 €	10000	12499,9999	3
12.500 - 15.000 €	12500	14990,9999	4
15.000 - 20.000 €	15000	19999,9999	5
20.000 - 25.000 €	20000	24999,9999	6
25.000 - 30.000 €	25000	29999,9999	7
30.000 - 40.000 €	30000	39999,9999	8
40.000 - 50.000 €	40000	49999,9999	9
> 50.000 €	50000	100000000	10
(Blank)			11

So that I can have : 

Idperson	Salary	Rev ménage (groups)
57927	14 669,47 €	12.500 - 15.000 €
63584	10 616,88 €	10.000 - 12.500 €
63581	20 584,60 €	20.000 - 25.000 €
48460	10 712,40 €	10.000 - 12.500 €
56542	10 712,38 €	10.000 - 12.500 €

How can I tell that power bi ? It's a sort of lookupvalue but that takes in account the max and min value. 

Any ideas? 

Thanks in advance! 

Ana 

[Mariusz · Accepted solution]

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.

[AFra]

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]

                 )

)

[Mariusz]

Hi @AFra 

Happy to help!

Best Regards,
Mariusz

Please feel free to connect with me.