Search code examples
desktop-applicationpowerbipowerbi-datasource

Count the number of filtered values


I have a table has 2 columns:

enter image description here

I want to summarize these data in new table as follow:

enter image description here

what is the expression will help to do this?

I dont need to use the MATRIX

Regards,


Solution

  • here is my solution that helped me out to do the needful, Matrix is nothing for the required.

    http://community.powerbi.com/t5/Desktop/count-number-of-filtered-rows/m-p/86501#M36295