Trying to get a view using DAX

[Anonymous]

Hi, I am very new user to Power BI. I have a situation where I have sample data as below - 

Groups	Work Status	Work id
abc	Status1	1
abc	Status2	2
def	Status2	3
def	Status2	4
def	Status3	5

Can I have a DAX a formula to have a table like

Count of Work id	Column Labels
Row Labels	Status1	Status2	Status3	Grand Total
abc	1	1		2
def		2	1	3
Grand Total	1	3	1	5

thanks,

[Payeras_BI · Accepted solution]

Hi @Anonymous ,

Use the Matrix visualization like below:

Regards,