How to get week wise summary count based on group by using DAX in power bi

Hi, saivina2920 

Step 1: Add two new columns to the original table

Step 2: Create a duplicate table and convert it to the output table above

Step 3: Create a relationship between the two tables

Step 4: Create a report page(details of the summary list) to filter items whose comments are not empty in the filter pane

Step 5: Add drill-through fields in page2(details of the summary list)

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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