Forum Discussion

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
2 years ago

Matrix Design

Hello
I would like to design a Matrix.
Is it possible to have 2 columns with the same data. The data is from Direct Query.

- One with higher than version 2.x

- One with less than version 1.9
Do I have to do a Measure or can it be done easier?
Once it is done I would also like to drill down to see who has one of the 2 versions.
Can I insert the drill down and add the User into the "Drill through" field
Regards

Heinrich

Need Help
Show and Tell
Tips and Tricks

6 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi Heinrich ,

     

    Can you elaborate a little bit more on the:

     

    - One with higher than version 2.x

    - One with less than version 1.9

     

    Does this information already exists on your model or you only have a single column?

    • Heinrich's avatar
      Heinrich
      Icon for Post Partisan rankPost Partisan
      2 years ago

      Hello Miguel

      I have one single column.

      In this column "Versions" you have different Versions.

      This column (String) has following data

      Version 1.1

      Version 1.2

      Version 1.3

      Version 2.1

      Version 2.2

      Version 2.3

      Version 2.4

      I could limit it to 

      - 1 Measure to search only 1.2

      - 1 Measure to search only 2.3

      Every Data is on Direct Query

      Thank you for your help

      JFM_12

      - 

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        2 years ago

        In this case being in Direct Query, the best option is to create the measures since you have the values on a specifc column.