Two Measures required on same column based on different values

[PaisleyPrince]

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

[Anonymous · Accepted solution]

Hi @PaisleyPrince ,

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

Best Regards,

Wearsky

[Anonymous]

Hi @PaisleyPrince ,

Have a good day. Could you describe the desired output and share virtual sample data?

Best Regards,

Wearsky

[PaisleyPrince]

Hi,

I've attached sample input and output. @tamerj1 is correct that i'm currently using SELECTEDVALUE.

[tamerj1]

@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]

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

[tamerj1]

@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]

Hi @PaisleyPrince 

use MAX