Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a transactional data base that contains ID, Date, Sales. I have aggregated sales value at the ID level and can filter by using Date
Using the following data, I've created a cumulative sales value at the ID level, that changes with the date filter
sumsales = CALCULATE ( sum ( 'Sheet1'[Sales] ), FILTER ( 'Sheet1', 'Sheet1'[Date] >= MIN ( 'Sheet1'[Date] ) && 'Sheet1'[Date] <= MAX ( 'Sheet1'[Date] ) ))
I now want to use to above sumsales as a filter, so that when date filter is changed, the corresponding values in the sumsales filter should also change. For example, if I choose the date range slicer to be between 09/01/2018 - 12/01/2018, the sumsales filter should only contain values for that time period. Can someone please help me here.
Attaching the link of the sample powerBI.
https://drive.google.com/open?id=11of5z6dcD5Fa6Z-Ynfz2O9WbGC0erMQ4
Thank you in advance.
Hi @navin1491,
The measure will be changed by the date slicer by default . However, as I know, we cannot filter the table by a measure.
I now want to use to above sumsales as a filter, so that when date filter is changed, the corresponding values in the sumsales filter should also change. For example, if I choose the date range slicer to be between 09/01/2018 - 12/01/2018, the sumsales filter should only contain values for that time period.
If you choose the date range slicer, then the table will be filterd at the same time. Then the measure will be changed accrodingly. Please figure it out if I did not understand.
Regards,
Frank
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |