calculate the average

[adriano321souza]

Good Morning!
I have the following problem:
I want to calculate the average of the values ​​shown on the screen from the TOPN filter, that is, when selecting one of the TOPN items to print the average on a card.
Thankful!

Exemple

[adriano321souza]

in the top 10 is it possible to show only the values ​​of the first 10 lines?

[v-juanli-msft · Accepted solution]

Hi @adriano321souza 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft]

Hi @adriano321souza 

It is possible, based on my pbix, 

create a measure

Measure = IF([rank]<=[selected],1,0)

Add this measure in your visual level filter and apply 1

Best Regards

Maggie

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

[v-juanli-msft]

Hi @adriano321souza 

Please check my pbix,

create measures as below

value = SUM(dRelAtend[Valor])

rank = RANKX(ALL(dRelAtend[Cliente]),[value],,DESC,Dense)

selected = SELECTEDVALUE(TopNTable[TopNValues])

count = CALCULATE(DISTINCTCOUNT(dRelAtend[Cliente]),FILTER(ALL(dRelAtend[Cliente]),[rank]<=[selected]))

sum = SUMX(FILTER(ALL(dRelAtend[Cliente]),[rank]<=[selected]),[value])

average = [sum]/[count]

Best Regards
Maggie

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