Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have this dax function that counts blank rows based on condition.
No MTM Scan (OnTime) =
CALCULATE (
COUNTROWS ( 'GMS Flat File' ),
FILTER (
'GMS Flat File',
'GMS Flat File'[On_Time_Inb_Stretch_HTD] = 1
&& 'GMS Flat File'[Dest_Route_City_Nm] = "Wellington"
&&
'GMS Flat File'[MTM Entry Scan] = BLANK() || 'GMS Flat File'[MTM Exit Scan] = BLANK()))
The function returns incorrect result. It should be 11 rows as highlighted cells in screenshot below. The coutrows should be counting rows and not the cell.
Solved! Go to Solution.
hi @Anonymous
so you get more than 11?
if so try like:
No MTM Scan (OnTime) =
CALCULATE (
COUNTROWS ( 'GMS Flat File' ),
FILTER (
'GMS Flat File',
'GMS Flat File'[On_Time_Inb_Stretch_HTD] = 1
&& 'GMS Flat File'[Dest_Route_City_Nm] = "Wellington"
&&
( 'GMS Flat File'[MTM Entry Scan] = BLANK() || 'GMS Flat File'[MTM Exit Scan] = BLANK())))
hi @Anonymous
so you get more than 11?
if so try like:
No MTM Scan (OnTime) =
CALCULATE (
COUNTROWS ( 'GMS Flat File' ),
FILTER (
'GMS Flat File',
'GMS Flat File'[On_Time_Inb_Stretch_HTD] = 1
&& 'GMS Flat File'[Dest_Route_City_Nm] = "Wellington"
&&
( 'GMS Flat File'[MTM Entry Scan] = BLANK() || 'GMS Flat File'[MTM Exit Scan] = BLANK())))
User | Count |
---|---|
51 | |
36 | |
20 | |
15 | |
13 |
User | Count |
---|---|
94 | |
72 | |
29 | |
22 | |
14 |