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.
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!
Solved! Go to Solution.
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
in the top 10 is it possible to show only the values of the first 10 lines?
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
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.
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.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |