Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Philandcas
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"
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |