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

[saivina2920]

I have some sample data. In that, i just want to get week wise count of summary.

for example, below is my sample data (same has been attached in excel).

I have Project start Date. Using this we want to get week and the count of comments group by country.

Once we arrived the data as an output, when i click the row (highlighted in the output table), it should show the details of the summary list.

pls. find the sample data excel file in the line : https://1drv.ms/x/s!AiSRcgO5FUmN8VO5u-lrXEEJzL1e?e=2UzZs8 

How to achieve this using DAX...

[v-angzheng-msft · Accepted solution]

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.

[saivina2920]

Really awesome guidance...

[ronrsnfld]

I don't have time to explore it now, but perhaps this:  Set up drillthrough in Power BI 

[saivina2920]

Anyone can reply regarding the subject..this is very urgent..

[saivina2920]

Pls. give some idea to arrive this...This is urgent task...