0

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,

Aboud
  • 3
  • 3
  • 1
    If you don't want to use a Matrix, create a measure for each column: i.e the expression for New should be `New=COUNTAX(Table,[Col2]="New")`. Use each measure in the visualization you need. – alejandro zuleta Nov 06 '16 at 23:17
  • A Matrix seems the easy solution. – Mike Honey Nov 07 '16 at 23:08
  • 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 – Aboud Nov 15 '16 at 12:14

1 Answers1

0

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

Aboud
  • 3
  • 3