How to combine count of 2 categories

[ade_kurniawan]

Form the table below :

The output i want :

Please help, thank you

[ade_kurniawan]

I Need More : DAX Table for column count of category1 on Table1 that i give blue square :

[ade_kurniawan]

thanks very much @ponnusamy 

but please tell me how to create New Tables ?

[ponnusamy]

Are you pulling the data from the source?, Data from source usually brought in through tables. You can also use Excel or create a table within Power BI. 

[ponnusamy · Accepted solution]

@ade_kurniawan :  It should be straightforward.  I have two tables 

Have the relationship established , in your case, let us join using the category

Now go to the Report and insert table visual  and pull the following fields

If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.