Forum Discussion
Advocate IITwo 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
7 Replies
- tamerj1
Community Champion
use MAX
PaisleyPrinceHi, thanks for the advice - would you be able to elaborate ?
- tamerj1
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 😅
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
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.
