Forum Discussion
Replacing (blank) with 0
desarrolloaudit you have to simply add a measure like this and use this on each card as you are filtering each card
Count = COUNTROWS ( Table) + 0Use above measure in each card.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
What happens is that the values of that column are text, and the card only counts how many times that value appears in the column
Super Userdesarrolloaudit doesn't matter if it is a count of a text column or a sum of number column, at end both returns a number and +0 will do it.
If that's not your question, provide more context with examples. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- parry2k
desarrolloaudit I don't know what is the datatype of your columns, if you are trying to sum your text column, it will not work, you need to share sample data and what you are trying to achieve. if it is a text column then use count instead of sum. I'm shooting in the dark here,
I have this database with records of several people and in front it has an action that that person performed, the action column [Medida de prevención implementada] is in text format
I create these cards so that PowerBI can tell me how many records each action has using the filter so that the card selects only a specific action, along with the total sum of all the records that is in green
When I select a person who has 0 values in any action it appears on the card (Blank), I want to replace that (Blank) with the value 0