Top N for graph with 2x hierarchy data fields

[Leon12Smith]

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

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[amitchandak · Accepted solution]

@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])