The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I've been reading other messages regarding this same topic however I haven't found one that matches my scenario. I am looking for a way to replace the (Blank) result with a zero on my cards when the filter criteria results in no data to be reported. Other messages were solved by putting +0 at the end of their calculate measure but my DAX does not include calculate.
Encounters Table
Scenario:
I want to know how many encounters are over 30 days old. I've created a calculated column that returns a 0(false) or 1(true) value.
Encounter Older Than 30 Days? = IF ( Encounters[Encounter Date] > ( TODAY () - 30 ), "0", "1" )
The card works as anticipated until I drill down and apply visual level filters. More specifically, my issue occurs when I'm filtering by "Encounter status" = Open, Review or Pend and "Assigned to" = jzechmann
Jzechmann does not have any records in an open, review or pend status so I would like the card to reflect 0 rather than blank.
I'm sure this must be possible, what do I need to do and/or change to make this work?
Hi @TabathaN,
It seemed that you could use the isblank function to filter your data firstly. Due to I could not reproduce your problem with below condition:
Could you please share a sample file to have a test if possible?
Regards,
Daniel He
As there are no rows matching your condition, it shows blank. In the calculation of your card, you must specify something like IF(EMPTY(filteredtable);"0")
If you provide more info about your visuals, we will be able to help you better.
Hi @TabathaN
What are you placing exactly on the card? Is it your calculated column with some sort of summarization (count, etc.) ?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
80 | |
78 | |
43 | |
37 |
User | Count |
---|---|
158 | |
111 | |
64 | |
59 | |
54 |