Forum Discussion

Leon12Smith's avatar
Leon12Smith
Frequent Visitor
3 years ago
Solved

Top N for graph with 2x hierarchy data fields

Hi

I have a table called Vehicles - it contains a hierarchy field "Make and Model" of vehicles showing the vehicles "Model" and specific connected "Make":


I am plotting a Column Chart with this mentioned field as the x-axis with a calculated measure on the y-axis - call it "y_axis_measure".


I want to filter the graph to only show the top 10 "Make and Model" vehicles by the "y_axis_measure". But I do not have this option available on the Filters pane. 

I can only filter by either Vehicle[Make] or Vehicle[Model]:


Can I create a measure or filter to only show the top 10 Vehicles Make and Model by the "y_axis_measure"? In other words, the top 10 "y_axis_measure" values of the Vehicles in the Vehicles table based on the combination of the Make and Model description.

Thanks

  • amitchandak's avatar
    amitchandak
    3 years ago

    Leon12Smith , Try like this examples

     

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

     


    2 column top N = Sumx(Keepfilters( TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[make], 'Item'[Model]), [Your measure],DESC)), [Your measure])

2 Replies

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

    Leon12Smith , Try like this examples

     

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

     


    2 column top N = Sumx(Keepfilters( TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[make], 'Item'[Model]), [Your measure],DESC)), [Your measure])