Forum Discussion

adriano321souza's avatar
adriano321souza
Frequent Visitor
7 years ago
Solved

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 aver...
Need Help
Show and Tell
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

adriano321souza's avatar
adriano321souza
Frequent Visitor
7 years ago

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

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.