Count cells in whole table and create a slicer

[DM_BI]

Hello, 

Let's say I have a table of two columns. In each column it can be wirtten "OK" or "KO". I need to know how many cells are "OK" in my whole table. Is it possible? For the moment I create a measure for each column (like in the sample) but very fastidious.

Then I want to create a slicer OK/KO so that when I chose OK I see in graph how many OK I have per column.

Here is the sample document but I have several columns and rows in my real excel.
https://www.dropbox.com/s/onltywhqy83bomu/Sample%20OK%20KO.pbix?dl=0 
https://www.dropbox.com/s/yqwvlnj3jm62wtc/Sample%20OK%20KO.xlsx?dl=0

Thank you!

[v-chuncz-msft · Accepted solution]

@DM_BI ,

You just need to select Unpivot Columns in Query Editor first.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415

[DM_BI]

Thank you very much!!

It worked perfectly. In my real table I used "unpivot selected columns" and I don't how it works but it works so thank you!!