Forum Discussion
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 wit...
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])
Ashish_Mathur
Super User
Super UserHi,
Share some data to work with and show the expected result.