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 morning,
The other day Ashish gave me a solution to a problem "Housing NENA PastDue = Calculate(COUNT('NENA Tickler'[housing]),'NENA Tickler'[housing] = "PastDue")', However, if the column has no "PastDue"s, the Visualization Card displays the text "(Blank)". How can I modify the Calculate(Count( so that insteat of the text "(Blank)", the card displays either a numeric 0 or the text "All up to date"? Assistance would be greatly apporeciated.
Thanks
Solved! Go to Solution.
Hi @JoseAriel,
You're welcome. Please mark the right reply as answer, so more people will find solution easily.
Best Regards,
Angelia
This is a terrible solution and it doesn't work.
Hi @JoseAriel,
As I tested, please plus 0 at the end of formula as follows.
Housing NENA PastDue = Calculate(COUNT('NENA Tickler'[housing]),'NENA Tickler'[housing] = "PastDue")+0
Please feel free to ask if you have any other issue.
Best Regards,
Angelia
amazing solution!
Thanks much. Learning sooo much from your skills.
Hi @JoseAriel,
You're welcome. Please mark the right reply as answer, so more people will find solution easily.
Best Regards,
Angelia
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |