The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
26 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
11 | |
9 | |
8 |