Forum Discussion
Replacing Card Content if value is Blank
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
Super UserAnonymous 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.⚡
Yes, I set the relationships already. Are you saying that the filters are set visually, to the card I apply the measure to?
- parry2k
Anonymous if you have slicer on the page for those columns, as you select a value, card visual value will change. Tables get filtered once you choose the value and based on the filter applied on the tables, you measure will updates accordingly and so do card visual. You have to test it to check the result and then ask the question otherwise my answers are not going to make sense. if something doesn't work, please explain what is not working and what you have tried.