Forum Discussion
Please Help! :)
Hi All,
I am new to the community, but love all the feedback on here, soooo helpful!
I had one question - I am trying to set up a "Card" in Powerbi where the total spend for a person shows up only, but the cavaeat, I need to do this for multiple people (17) without having to filter. How would I do this? I was able to get the persons name alone on a card without having to filter - I used count of the total in one measure and then used "IF" statement for another measure, then Name of person which worked. When trying this for spend, no luck. I attached a picture for an example. Any information is greatly appreciated!
So if you want to do it explicitly in a measure you'd do something like:
Person A Total =
CALCULATE (
[Total Spend],
Table[PersonName] = "Person A"
)
However it would be far easier to just use the total spend measure in each card and set a visual level filter (pane on right hand side) direct to it. You can lock it and hide it so end user can't change it.
Thank you sooo much for the speedy response, this was very helpful! 🙂
If I run into any issues I will reach back out.
Have a great week!
2 Replies
So if you want to do it explicitly in a measure you'd do something like:
Person A Total =
CALCULATE (
[Total Spend],
Table[PersonName] = "Person A"
)
However it would be far easier to just use the total spend measure in each card and set a visual level filter (pane on right hand side) direct to it. You can lock it and hide it so end user can't change it.
Thank you sooo much for the speedy response, this was very helpful! 🙂
If I run into any issues I will reach back out.
Have a great week!