Split query into 1 table with 4 areas

Question

I have a query which in the area it has values of&nbsp;&nbsp;project&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Area1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ncsa2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mena3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; apac4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; earc5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ncsa&nbsp;&nbsp;I would like to split each row based on the area into a table that counts the number of projects based on the area. for example,&nbsp;table 1&nbsp;# of projects in area&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; area5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mena3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; apac&nbsp;how can I split my query or use DAX to create a new table

alb · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
The example is a bit confusing. I'm not sure I understand correctly. Create a new calculated table:
NewTable =
ADDCOLUMNS (
    DISTINCT ( Table1[Area] ),
    "NumProjects", CALCULATE ( COUNT ( Table1[project] ) )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers&nbsp;&nbsp;

Forum Discussion

Split query into 1 table with 4 areas

2 Replies

Related content

Split a table in Power Query

Split Query for Tables

Table Query

Split Table

Power Query Tables