March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Thanks ahead for you advice on this.
I have a variable that determines the year:
var _year = 2020
and one variable that collects a value:
year | pool | headcountMin | headcountMax |
2020 | A | 5000 | |
2020 | B | 2001 | 5000 |
2020 | C | 1001 | 2000 |
2020 | D | 501 | 1000 |
2020 | E | 251 | 500 |
2020 | F | 101 | 250 |
2020 | G | 1 | 100 |
2021 | A | 5000 | |
2021 | B | 4001 | 5000 |
2021 | C | 2501 | 4000 |
2021 | D | 501 | 2500 |
2021 | E | 301 | 500 |
2021 | F | 201 | 300 |
2021 | G | 1 | 200 |
Solved! Go to Solution.
Hi @DavidMG82,
Please try this measure:
In plain text:
Measure =
VAR _year = 2020
VAR _headcount = 550
RETURN "Pool '" & MINX ( FILTER ( data, [year] = _year && _headcount >= [headcountMin] && _headcount < [headcountMax] ), [pool] ) & "'"
Best Regards,
Alexander
Hi @DavidMG82,
Please try this measure:
In plain text:
Measure =
VAR _year = 2020
VAR _headcount = 550
RETURN "Pool '" & MINX ( FILTER ( data, [year] = _year && _headcount >= [headcountMin] && _headcount < [headcountMax] ), [pool] ) & "'"
Best Regards,
Alexander
Works as expected, thanks Alexander.
User | Count |
---|---|
122 | |
98 | |
89 | |
76 | |
68 |
User | Count |
---|---|
139 | |
115 | |
114 | |
98 | |
98 |