Display first 5 rows using DAX in Power BI

[amolgharge]

I am new to Power BI. I have a table named 'Mobile Sales Data' having two columns 'Sales Date' and 'Total Sale' as shown here. Its date wise sale amount.

I want to show -

1. First 5 rows i.e. 09,09,09,10,10 October 2021 records ( from sale amount 61,048.20 to 1.27.819.90)  datewise with Total Sale. I tried a lot but not getting required output. Kindly  provide me DAX .

Thank You.

[bhanu_gautam]

@amolgharge 

If you want to create a measure to filter the first 5 rows in a visual, you can use the following DAX formula:

DAX
First5RowsMeasure =
IF(
RANKX(
ALL('Mobile Sales Data'),
'Mobile Sales Data'[Sales Date],
,
ASC
) <= 5,
1,
0
)

You can then use this measure in your visual filters to show only the rows where First5RowsMeasure equals 1.