Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I have a scenairo in which I have to display 2(Sales, Sales_History) measure values by Region having 'Month-Year' as a filter. Consider like I have data for each day from Jan 2016 to July 2017 and I applied filter as Mar-2017. then valuse for measures should be as below
Sales:- Should display data for Mar-2017 month only.
Sales_History:- Should display data from Jan 2016 to Mar 2017.
For e.g
Sales Sales_History
--------------------------------------------------------
Region1 20 235 (Sum from Jan 2016 to Mar 2017 for Region1)
Region2 25 225 (Sum from Jan 2016 to Mar 2017 for Region2)
Region1 15 215 (Sum from Jan 2016 to Mar 2017 for Region3)
Region1 22 205 (Sum from Jan 2016 to Mar 2017 for Region4)
Please anyone let me know how this can be done in Power BI.
Regards
Saket
Solved! Go to Solution.
This requirement can be done by a cumulative total. Please refer to the steps below to see the details.
Regards,
Charlie Liao
This requirement can be done by a cumulative total. Please refer to the steps below to see the details.
Regards,
Charlie Liao
Hi Charlie,
Thanks for your previous response. It helped me a lot.
In continuous to our discussion, I have the same requirement but with some change. In previous measure calculation we applied filter based on Region. But now I am looking for a calculated measure which don't have any filter.
So that we can display the measure column not only with Region but also with other dimension column e.g. Product Category, Sales Type.
I tried doing that but didn't figure it out. So Please let me know if you can help me out with this requirement.
Regards
Saket
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
27 | |
17 | |
15 | |
8 |
User | Count |
---|---|
46 | |
38 | |
34 | |
17 | |
16 |