Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jeremiah209
Regular Visitor

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! 

 

Jeremiah209_2-1659332863238.png

 

 

 

2 ACCEPTED SOLUTIONS
bcdobbs
Super User
Super User

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

Jeremiah209
Regular Visitor

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! 

View solution in original post

2 REPLIES 2
Jeremiah209
Regular Visitor

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
Super User
Super User

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.