Sorting DAX measure of Current Year Actual net sales

[Palikaros]

Hello,

I have created the below DAX measure, where I am calculating current year net sales at Prior Year Rate for some products.

CY Actual Net Sales at PY = CALCULATE([CY Actual at PY], 'Report Line'[Report_Line_Parent]="Net Sales").

Is it possible with a DAX measure to create the top 5 of the above with descending order? Of course, values should be dynamic based on user`s selection of country and quarter, which are done through slicers.

I know that it is possible to do sorting within a visual, but since i want to sort the visual also per year, i would like to have already sorted the top 5 products with descending order from a DAX measure.

Thank you in advance.

[FreemanZ · Accepted solution]

yes, you shall check the TOPN function, but it returns a table instead of a scalar value. You may aggregate based on the TOPN table. 

https://dax.guide/topn/