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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PaisleyPrince ,

 

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

 

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.