Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone
I have a data set that looks like the below.
What I'm after is to be able to display the average price for the location in which the selected customer resides. In an ideal world I'd have a slicer in which an end user can select e.g. "Joe Bloggs" and then have a measure into a card which would display the average price of people in London, e.g. £163.75.
Hoping someone can help with what this measure would look like as I'm a bit stuck!
Thanks
Customer Name | Location | Price |
Joe Bloggs | London | £100.00 |
Dan Smith | Newcastle | £50.00 |
Susie Campbell | Newcastle | £78.00 |
Kylie Minogue | Brighton | £135.00 |
David Beckham | London | £180.00 |
Theresa May | London | £250.00 |
Beyonce | London | £125.00 |
Solved! Go to Solution.
@Anonymous try this measure
Avg = VAR __location = MAX( Table2[Location] ) RETURN CALCULATE( AVERAGE( Table2[Price] ),ALL(Table2 ), Table2[Location] = __location )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous try this measure
Avg = VAR __location = MAX( Table2[Location] ) RETURN CALCULATE( AVERAGE( Table2[Price] ),ALL(Table2 ), Table2[Location] = __location )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you!!
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |