Forum Discussion

Jeremiah209's avatar
Jeremiah209
Regular Visitor
4 years ago
Solved

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...
Need Help
Tips and Tricks
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    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's avatar
    Jeremiah209
    4 years ago

    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's avatar
bcdobbs
Community Champion
4 years ago

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.