Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a parameter for users to select the quarter of the year so the list should be 1 to 4.
When I run the parameter query there is a null (see screenshot). I think it's causing issues for other paramaters, is there a way to remove this null?
Solved! Go to Solution.
Method 1:
EVALUATE
FILTER(
SUMMARIZECOLUMNS(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Method 2
EVALUATE
FILTER(
DISTINCT(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Method 3
EVALUATE
FILTER(
DISTINCT(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Proud to be a Super User!
This also helped me with select all as a default value. I was strugling with it for so long.
Method 1:
EVALUATE
FILTER(
SUMMARIZECOLUMNS(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Method 2
EVALUATE
FILTER(
DISTINCT(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Method 3
EVALUATE
FILTER(
DISTINCT(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Proud to be a Super User!
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |