Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I'm trying to create two measures based on slicer selections, which use the same column (location) as per below. The output would
be a matrix showing Description and total stock quantity for the first and second locations chosen (one measure for each). I have tried using SELECTEDVALUE as a filter for the measures but this throws an error. Any advice would be greatly appreciated.
thanks
Scott
Solved! Go to Solution.
Hi @PaisleyPrince ,
Have a good day. Could you describe the desired output and share virtual sample data?
Best Regards,
Wearsky
Hi,
I've attached sample input and output. @tamerj1 is correct that i'm currently using SELECTEDVALUE.
Why don't you just use a matrix visual? Description in the rows, Location in the columns and Stock quantity in the values. I hope you're not over simplifying the problem.
Hi, thanks for the advice - would you be able to elaborate ?
My guess is that you're using SELECTEDVALUE to retrieve the slicer selection of a parameter table. If this the case then you need to use MAX or MIN to retrieve that value instead of using SELECTEDVALUE which if used you'll receive an error.
If I guessed wrong then you're the one who needs to elaborate not me 😅
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
15 | |
13 | |
11 | |
9 | |
8 |