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.
Dear Community,
I have Weekly_N table where I add daily scores for different subjects. How I can get average or total of scores(skills_workingwithdata) based on subject for all users?
2.05.2021 | Namiz | Namiz | Athletic | skills_workingwithdata | 20 |
2.05.2021 | Namiz | Namiz | Athletic | skills_digitalapproaches | 40 |
2.05.2021 | John | Smith | Recreational | behavior_keepingCurrent | 25 |
2.05.2021 | John | Smith | Recreational | behavior_collaboration | 20 |
2.05.2021 | John | Smith | Recreational | behavior_seekinginsight | 7 |
2.05.2021 | John | Smith | Recreational | mindset_curiosity | 27 |
2.05.2021 | John | Smith | Recreational | mindset_experimnting | 17 |
You can achieve this directly from the visual as shown below:
If the score field is a numeric field (integer, decimal, etc...) in your model, then Power BI will automatically calculate the sum depending on what fields you include in the table visual. If you want the average instead, you can simply go to fields and then choose summarize by average as shown below:
I need to use this aggregation for further visualizations. This is original table, where the data will be come
From this table I need to get daily sub_pillar totals by subpillars in order to use for visualizations. It need to be updated dynamically in order changes on original data table like
<subpillars> <date> <total subpillar_points>
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |