How to use DAX to create cross tabular analysis?

[Anonymous]

Hi all,

I am wondering how do I use PowerBI to create cross tabular tables or analysis? I used Excel pivot tables to create a cross tabular analysis below. The Vertical metric is 'Job Titles' and the horizontal metric is 'Industry'.

I am wondering how do I do the same with PowerBI?

I also attached how the pivot table is structured:

Thank you! 🙂

Ashley

[AlB · Accepted solution]

Hi @Anonymous 

It's pretty much the same in Power BI. You can use a matrix visual. Drag it into the work area from the Visualizations pane and place Job Title in rows and Industry in columns. Then place Job title in values as well and select Count

Or for the last step, you can create a measure and place it in values:

Measure = COUNT(Table1[Job Title])