Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
In the below meaure the bolded part doesn't filter or make any difference to the outcome. when I apply the same filter in filter pane it works.
Please help.
Q1.a New =
CALCULATE(
COUNTROWS(
FILTER(
TABLE1,
(TABLE1[Type] = "A" ||
TABLE1[Type] = "B" ||
TABLE1[Type] = "C" ||
TABLE1[Type] = "D" ||
TABLE1[Type] = "E" ||
TABLE1[Type] = "F" ||
TABLE1[Type] = "G" ||
TABLE1[Type] = "H" ||
TABLE1[Type] = "I") &&
(ISBLANK(TABLE1[DECISIONDATE]) || TABLE1[DECISIONDATE] >= [SelectedStartDate]) && TABLE1[VALIDDATE]<[SelectedStartDate]
)
)
)
Solved! Go to Solution.
@Libin7963 Try simplifying this and this is my best guess as to the logic you are going for.
Measure =
VAR __Table =
FILTER(
'TABLE1',
[Type] IN { "A", "B", "C", "D", "E", "F", "G", "H", "I" } &&
(
ISBLANK([DECISIONDATE]) ||
[DECISIONDATE] >= [SelectedStarteDate] && [VALIDDATE]] < [SelectedStartDate]
)
)
VAR __Result = COUNTROWS( __Table )
RETURN
__Result
@Libin7963 Try simplifying this and this is my best guess as to the logic you are going for.
Measure =
VAR __Table =
FILTER(
'TABLE1',
[Type] IN { "A", "B", "C", "D", "E", "F", "G", "H", "I" } &&
(
ISBLANK([DECISIONDATE]) ||
[DECISIONDATE] >= [SelectedStarteDate] && [VALIDDATE]] < [SelectedStartDate]
)
)
VAR __Result = COUNTROWS( __Table )
RETURN
__Result
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |