How to count occurrences for a Power BI Report Table visual

Hi strongr 

In power query, you can use group by to achieve this goal.

You can duplicate the table first

Then in the new table you can create a new step and input the following code.

Table.Group(#"Changed Type", {"Resource name"}, {{"Number of Project", each List.Count(List.Distinct([Projects])), Int64.Type}, {"Number of Tasks", each List.Count(List.Distinct([Task])), Int64.Type}})

Output

And you can refer to the attachments.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

You can do by using advance grouping.

• Advance Grouping

• Output: