Please Help! :)

[Jeremiah209]

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! 

[bcdobbs · Accepted solution]

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.

[Jeremiah209 · Accepted solution]

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! 

[bcdobbs · Accepted solution]

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.