How to count frequency?

[Tze]

Hi there,

I have this dump file from a program, which tracks the number of configurations made by users in a week.

The data looks like this:

Country - Product Model - User - Week no. which the configuration was created

Australia - E1 - Steve - 22

China - P1 - Tracy - 39

Australia - P1 - Larry - 36

etc.

I am trying to get the PowerBI to show weekly tracking for:

1. How many E1 or P1 was configured by country

2. How many total configurations (E1+P1) were done by country

I can't seem to get the PowerBI to count the no. of times which country or product appeared. It takes the week no. as numeric and sums it all up.

Anyone could help?

Thank you.

Regards,

Tze

[v-jiascu-msft · Accepted solution]

Hi @Tze,

You can do it simply. Drag the columns to a Table visual. Change the calculation type to Count. You can try it in this file: https://1drv.ms/u/s!ArTqPk2pu-BkgTbcFDsRptsBxCzT.

Best Regards!

Dale

[Tze]

Thank you Dale.