Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
My SALES YTD expression as below :-
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 :-
Paul Yeo
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |