Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago
Solved

Perform Measure on Matrix Values

I have a dataset similar to... Person 1 Active Person 2 Active Person 3   Person 4 Active Person 5   Person 6     The a Matrix Visual similar to... Person 1 Active ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi StuartSmith ,

     

    Please refer to my .pbix file.

    Note: First copy and paste the table data(2), then unpivot columns '4G', '5G', 'Esim', 'Porting', then you can get table 'date(3)'.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago

Thanks, but get...

 

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago

Whats "Active" as tried googling it and cant find anything about it.

  • StuartSmith's avatar
    StuartSmith
    Power Participant
    5 years ago

    or another option would be to create "Reference" tables from the origianl table, just containing the coulmns I need and then I can perform a count rows without having to filter the rows that are not included in the matrix.

     

      • StuartSmith's avatar
        StuartSmith
        Power Participant
        5 years ago

        Hi Lionel, I have uploaded an example of what I am trying to achieve.  Hope it makes sense.

         

        Stu

         

        Example (drop box)