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.
Good afternoon experts,
Hoping someone can highlight my error in the below Measure.
Essesntially I need a count of ID's between two dates, within a KPI value (14). Where I fall over is the OR (||) line.
I only want to count where a sale is "CLOSED" OR if another value is isblank.
Is this the correct way of deriving this count?
Cheers
Phil
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.
KPI =
CALCULATE (
DISTINCTCOUNT ( 'Table 1'[ID] ),
FILTER (
ALLSELECTED ( 'Table 1' ),
(
'Table 1'[Status] = "Closed"
|| ISBLANK ( 'Table1'[column 2] )
)
&& 'Table 1'[Days between] <= 14
&& 'Table 1'[Date Received] >= DATE ( 2022, 7, 1 )
&& 'Table 1'[Date Received] <= DATE ( 2023, 6, 30 )
&& 'Table 1'[Team] = "Team awesome"
)
)
Hi @Anonymous
please try
KPI =
CALCULATE (
DISTINCTCOUNT ( 'Table 1'[ID] ),
FILTER (
'Table 1',
'Table 1'[Status] = "Closed"
|| 'Table 1'[column 2] = BLANK ()
&& 'Table 1'[Days between] <= 14
&& 'Table 1'[Date Received] >= DATE ( 2022, 7, 1 )
&& 'Table 1'[Date Received] <= DATE ( 2023, 6, 30 )
&& 'Table 1'[Team] = "Team awesome"
)
)
Hi,
I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.
KPI =
CALCULATE (
DISTINCTCOUNT ( 'Table 1'[ID] ),
FILTER (
ALLSELECTED ( 'Table 1' ),
(
'Table 1'[Status] = "Closed"
|| ISBLANK ( 'Table1'[column 2] )
)
&& 'Table 1'[Days between] <= 14
&& 'Table 1'[Date Received] >= DATE ( 2022, 7, 1 )
&& 'Table 1'[Date Received] <= DATE ( 2023, 6, 30 )
&& 'Table 1'[Team] = "Team awesome"
)
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |