Solved: How to count frequency?

Tze · ‎10-17-2017

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 · ‎10-17-2017

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

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

View solution in original post

v-jiascu-msft · ‎10-17-2017

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

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