Calculate first 10 Sales from a selected date

[Anonymous]

Good morning

I have a measure [Total Sales]. I'm looking to have a new measure to show the first 10 records from a selected date range that then calculates the [Total Sales] 

Thank you in advance

[Anonymous]

Thank you @v-cgao-msft 

Thats the solution I eventually came up with too. 

[v-cgao-msft · Accepted solution]

Hi @Anonymous ,

Not very clear, By what rules are these 10 records filtered? 
Try using filtering on visual objects to see if this solves the question.

Attached PBIX file for reference.

If this doesn't work for you, would you mind providing some data that does not contain private information?

It makes it easier to give you a solution.

1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Community Support Team Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!