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

The Matrix is set like this. 

 

 

And I want to have a card, pie chart, etc showing the percentage of rows (Matrix values) that are not blank.  Bearing in mind, the matrix only contains a sub-set of the data set, so unable to simply count all the rows of the dataset and calculate the percentage that are empty.  

Hope that makes sense.