Forum Discussion
Solved
Count value in columns
Hello, I have something like this: Client col1 col2 col2 c1 OK OK OK c2 OK OK CRIT c3 WARN WARN OK c4 OK OK OK c5 OK CRIT OK c6 WARN OK OK c7 OK ...
Please check the solution at :https://www.dropbox.com/s/pzine68dy2tax7k/clientcount.pbix?dl=0
Unless you absolutely need it to be in a calculated column, you could drop col1/col2/col3 twice into the visual.
If you choose a table visual, drop the same column in the Value-well twice. The first one will show the distinct values in the column, and for the second one you choose the drop-down button on the column name in the Values-well, and choose Count.