Forum Discussion
Calculate first 10 Sales from a selected date
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
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.
- Sample (dummy dataset) data as text, use the table tool in the editing bar
- Expected output from sample data
- 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 GaoIf 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!
2 Replies
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.
- Sample (dummy dataset) data as text, use the table tool in the editing bar
- Expected output from sample data
- 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 GaoIf 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!