Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to use multiple value parameter in dax query. I am creating dataset for my cascading dropdown. For single value following query is working
EVALUATE
UNION (ROW("Sector","All"),
CALCULATETABLE(
DISTINCT('Rollup'[SectorName]),
'Rollup'[DivisionName] = @Division
))
but I need to use it for multiple values selected in Division which is not working
EVALUATE
UNION (ROW("Sector","All"),
CALCULATETABLE(
DISTINCT('Rollup'[SectorName]),
'Rollup'[DivisionName] IN (@Division)
))
Any idea or help will be appreciated.
@shzaidi , try like
EVALUATE
UNION (ROW("Sector","All"),
CALCULATETABLE(
DISTINCT('Rollup'[SectorName]),
'Rollup'[DivisionName] IN { @Division}
))
or
EVALUATE
UNION (ROW("Sector","All"),
CALCULATETABLE(
DISTINCT('Rollup'[SectorName]),
'Rollup'[DivisionName] IN @Division
))
The first suggestion syntax is correct but results are not. Selecting only one division it shows its sectors but selecting two or more divisions no sectors show up.
@shzaidi check if values or allselected works
'Rollup'[DivisionName] IN values( @Division)
'Rollup'[DivisionName] IN allselected( @Division)
Both has syntax errors, not accepting parameter value as table values even multiple values check in parameter is on.
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
13 |
User | Count |
---|---|
102 | |
55 | |
28 | |
19 | |
14 |