Forum Discussion

saivina2920's avatar
saivina2920
Post Prodigy
4 years ago
Solved

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

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...

 

 

Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    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.

5 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    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.