Forum Discussion

PaisleyPrince's avatar
PaisleyPrince
Icon for Advocate II rankAdvocate II
2 years ago
Solved

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 th...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi PaisleyPrince ,

     

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

     

    Best Regards,

    Wearsky

PaisleyPrince's avatar
PaisleyPrince
Icon for Advocate II rankAdvocate II
2 years ago

Hi,

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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

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.