Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Thank you Dale.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |