Forum Discussion
Replacing Card Content if value is Blank
Super UserAnonymous you can create a measure like this
Amount = SUM ( BookRevenueTable[Book Revenue] ) + 0and use above measure in the card visual
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.⚡
How would this handle the filters?
- parry2k
Anonymous what about filters?
from my question:
I have a Card View, that displays the sum of the column BookRevenue, with the following filters set:
On column BookType the filter is set to Fiction
On column PublicationYear filter is set to 2020
Your soliution will provide all the sum of All BookRevenue, when I only need the sum of BookRevnue, when BookType is Fiction and ProductionYear is 2020
- parry2k
Anonymous do you have set the relationship between your tables? you should set a relationship on BookCode between these two tables, and once it is done the same measure will work when you filter on those columns.
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.⚡