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.⚡
desarrolloaudit you can simply do +0
Measure = SUM ( Tabe[Amount] ) + 0
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
desarrolloaudit 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/38490I 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.⚡
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,