Forum Discussion
calculate the average
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!
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
4 Replies
v-juanli-msftCommunity Support
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
MaggieCommunity 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.in the top 10 is it possible to show only the values of the first 10 lines?
- v-juanli-msft
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
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.
