Forum Discussion
Replacing Card Content if value is Blank
How would this handle the filters?
Super UserAnonymous 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.⚡
Yes, I set the relationships already. Are you saying that the filters are set visually, to the card I apply the measure to?