Automatic Calculating scores

[Anonymous]

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

[Anonymous]

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:

[Anonymous]

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>