Expression to replace filter TOP N = 10 sales by Brand ?

[admin11]

Hi All,

My SALES YTD expression as below :-

Sales YTD = CALCULATE ( [SALES_M],DATESYTD('DATE'[Date]))

Now i am using filter to display Top 10 sales by Brand :-

May i know how to create a expression to replace above Top N filter on this visusal  ?

Sone thing like below , which is not work  :-

Flag Top 10 Brand = CALCULATE ( [SALES_M],DATESYTD('DATE'[Date],BRAND_5)TOP_N=10)

Paul Yeo

[Ashish_Mathur · Accepted solution]

Hi,

Drag Brand 5 to the rows section of a Table visual and drag this measure

=calculate([Sales_m],Top(10,all(Data[Brand_5]),[Sales_m]),values(Data[Brand_5]))

Hope this helps.

[Seanan]

Hi @admin11 

You can create new table using the following code and replacing [Company] for Brand and [Measure4] with your SalesYTD measure.

The "Total Sales" is the column name so you can name that anything you want.

TestingTop10 = TOPN(10,SUMMARIZE('SalesTeam','SalesTeam'[Company],"Total Sales",'SalesTeam'[Measure 4]))

 Then go to the relationships page and create a relationship using the brand column.

Once done you can use the columns from your new table to return the top 10 brands and then the rest of your measures/columns can be used from the original table.