Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Top & Bottom measure filter in same visual

Hi All,   I am working on a measure I want to see my top & bottom in the same visual for that I have written the query mentioned below but when I get my bar graph visual and put the name on the X a...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
2 years ago

Anonymous , Try a measure like this with TOPN or window

 

calculate(SUM(totalamount), KEEPFILTERS(SELECTEDVALUE(Slicer[Value]), ALLSELECTED(Table[Name]), CALCULATE(SUM(totalamount)),desc))
+ calculate(SUM(totalamount), KEEPFILTERS(SELECTEDVALUE(Slicer[Value]), ALLSELECTED(Table[Name]), CALCULATE(SUM(totalamount)),asc))

 

 

Just add top and bottom measure

 

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I am sorry I didn't understand do I replace this with the code that I have or add this in the code and do I apply anything on the visual filter ?