Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Leon12Smith
Frequent Visitor

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":

Leon12Smith_0-1684755018606.png


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".

Leon12Smith_1-1684755128999.png


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]:

Leon12Smith_2-1684755385436.png


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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.