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.
Reports NotSent Count = CALCULATE(COUNTA('Project Details'[Task Notes]),FILTER(ALL('Project Details'),'Project Details'[Task Notes]<>"No Issues"&&DATEVALUE('Project Details'[Task Completed At])=DATEVALUE(MAX('Project Details'[Task Completed At]))))
I am using following code to count number of reports not sent on a particular day.
Use case: If 0(Zero) reports not sent i.e. All reports are delivered then I should get 0(Zero) instead of "Blank"
Screenshot: http://prntscr.com/he8vs6
Solved! Go to Solution.
You want to put this in an IF statement and ask IF(ISBLANK(ReportsNotSentCount),0,ReportsNotSentCount), syntax probably wrong but you should get the gist of it
How to show the deafult value/data is null in powerbi table but when we have use the filter/slicer then show the data.
Hi @deepak91g,
Please follow the solution @jthomson posted. If you have resolved your issue, please mark the right reply as answer or welcome to share your own solution. If you haven't, you'd better post some sample table for further analysis.
Best Regards,
Angelia
You want to put this in an IF statement and ask IF(ISBLANK(ReportsNotSentCount),0,ReportsNotSentCount), syntax probably wrong but you should get the gist of it
Thank you so much it worked.
This worked for me thanks
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 |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |