Forum Discussion

_Junayetrahman's avatar
_Junayetrahman
Frequent Visitor
3 years ago
Solved

Dynamic TOP N On a table visual based on different dimension and fact columns

Hi I want to implement dynamic TOP N where user can input the value and see the top values. Considering a table visual where multiple fields are added from multiple dimensions. How to solve this one....
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    _Junayetrahman , Multicolumn TOPN can be achieved using

    example

     

    2 column top N = CALCULATE([Net], TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Brand], 'Item'[Category]), [Net],DESC),VALUES('Item'[Brand]), VALUES('Item'[Category]) )


    2 column top N = Sumx(Keepfilters( TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Product Category], 'Item'[Product Name]), [Total_sales],DESC)), [Total_sales])

     

    for Dynamic TOPN refer

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

_Junayetrahman , Multicolumn TOPN can be achieved using

example

 

2 column top N = CALCULATE([Net], TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Brand], 'Item'[Category]), [Net],DESC),VALUES('Item'[Brand]), VALUES('Item'[Category]) )


2 column top N = Sumx(Keepfilters( TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Product Category], 'Item'[Product Name]), [Total_sales],DESC)), [Total_sales])

 

for Dynamic TOPN refer

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

_Junayetrahman's avatar
_Junayetrahman
Frequent Visitor
3 years ago

2 column top N = Sumx(Keepfilters( TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Product Category], 'Item'[Product Name]), [Total_sales],DESC)), [Total_sales])

is fine but How to show all data in table visual instead of only 10?