Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |