Forum Discussion
PaisleyPrince
Advocate II
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 th...
PaisleyPrinceAdvocate II
Advocate IIHi, thanks for the advice - would you be able to elaborate ?
- tamerj1
Community Champion
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 😅
