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 everyone,
I'm struggling to handle an easy formula which is a nested average computed along a table with 2 dimension (AUTORE,LINK).
Basically I need to compute first of all an average for each author (AUTORE), and then use those aggregated values to create a second level average.
AUTORE LINK VALORE
autore_1 url_A 20
autore_1 url_B 20
autore_1 url_C 20
autore_1 url_D 20
autore_1 url_E 10
autore_1 url_F 10
autore_2 url_G 20
autore_3 url_H 5
For those familiar with Tableau, you could get the correct result with a nested Level of Deatil
I've already checked a similar post (https://community.powerbi.com/t5/Desktop/Average-of-average/m-p/1017894#M481085) but I'm not sure I'm understanding 100%, especially in my case where I have 2 dimension columns and one of them (LINK) is not involved in that caluclus.
Can anyone help?
Thanks in advance.
Fabio
Solved! Go to Solution.
The general pattern is:
Measure =
AVERAGEX(
SUMMARIZE(
'Table',
[Group],
"__Average",AVERAGE('Table'[Column])
),
[__Average]
)
The general pattern is:
Measure =
AVERAGEX(
SUMMARIZE(
'Table',
[Group],
"__Average",AVERAGE('Table'[Column])
),
[__Average]
)
thanks for your feedback.
It's exactly what I was looking for.
Regards
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 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |