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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
PaisleyPrince
Helper II
Helper II

Two Measures required on same column based on different values

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

PowerBI update.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @PaisleyPrince ,

 

As tamerj1's said, the matrix can meet your needs.

vxiaocliumsft_0-1727415465494.png

vxiaocliumsft_1-1727415532864.png

 

Best Regards,

Wearsky

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

Hi @PaisleyPrince ,

 

As tamerj1's said, the matrix can meet your needs.

vxiaocliumsft_0-1727415465494.png

vxiaocliumsft_1-1727415532864.png

 

Best Regards,

Wearsky

Anonymous
Not applicable

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.

Screenshot 2024-09-16 210128.png

@PaisleyPrince 

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. 

PaisleyPrince
Helper II
Helper II

Hi, thanks for the advice - would you be able to elaborate ?

@PaisleyPrince 

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 😅

tamerj1
Super User
Super User

Hi @PaisleyPrince 

use MAX

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.