Perform Measure on Matrix Values

[StuartSmith]

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
Person 3
Person 5
Person 6

I need to get the percentage of non-empty row displayed in the matrix.  So as there are 1 row with "Active" and 3 rows that are Empty, the card visual should show 75%.  Can you perform calculation on matrxi visuals?

[amitchandak]

@StuartSmith , Try like

divide(calculate(countrows(Table), filter(Table,isblank[Active])),countrows(Table))

or

divide(calculate(countrows(Table), filter(Table, not(isblank[Active]))),countrows(Table))

[StuartSmith]

Thanks, but get...

[StuartSmith]

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

[StuartSmith]

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.

[v-lionel-msft]

Hi @StuartSmith ,

Like this?

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]

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

Stu

Example (drop box) 

[v-lionel-msft · Accepted solution]

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]

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.