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.
Hello,
Need help with the conditional function like where. I want to count requestID where pending audit = blanks.
Solved! Go to Solution.
Hi, I think i got it
Hello
Try this :
Hi, the CA Omega'[Pending Audit] turns grey
Hi @xRTP
Please try
Number of Blank =
CALCULATE ( COUNTROWS ( 'CA Omega' ), 'CA Omega'[Pending Audit] = BLANK () )
Yah it works, but the thing is I want to depend it to requestID. Is it possible? Because my total request ID's that was blank is 113 and this code returns 115 rows
@xRTP
Not sure what do you mean but I gues you're looking for either
Number of Blank =
CALCULATE ( COUNT ( 'CA Omega'[Request ID ), 'CA Omega'[Pending Audit] = BLANK () )
or
Number of Blank =
CALCULATE ( DISTINCTCOUNT ( 'CA Omega'[Request ID ), 'CA Omega'[Pending Audit] = BLANK () )
Otherwise please provide one example
Hello,
My table name is CA Omega and Request ID and Pending Audit are my columns.
The thing is, i want to count RequestID that was blank in Pending Audit, i dont want to count Pending Audit alone because it also count my excel's blank item. Its like count RequestID where Pending Audit = blank.
Hi, I think i got it
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |