The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I'm trying to create a summary report with multi-row card which shows sum of a "value" column based on date range ("dt" column). I'm using measures to create sum of value based on date ranges, i.e. last 3 months, last 6 months, & past 1 year. Using that measures in a multi-row card & also categorizing by "plants" column. I also have another page which contains all the transaction data in a table. I'm able to drill through to transaction data table with "Plants" column filter.
How can I drill through to that transaction data table with date range as filter as well?
Note: I've only one data table.
Measures:
3Mo_sum = CALCULATE(SUM('public rawdata'[value]),DATESINPERIOD('public rawdata'[dt].[Date],MAX('public rawdata'[dt].[Date]),-3,MONTH))
6Mo_sum = CALCULATE(SUM('public rawdata'[value]),DATESINPERIOD('public rawdata'[dt].[Date],MAX('public rawdata'[dt].[Date]),-6,MONTH))
12Mo_sum = CALCULATE(SUM('public rawdata'[value]),DATESINPERIOD('public rawdata'[dt].[Date],MAX('public rawdata'[dt].[Date]),-12,MONTH))
Data Model: There is only one table which contains Transaction data.
Thanks.
Hi @yug_ck ,
In this case you do not have the date context to act has a filter since what you have is the filter context on the formula, when you use the measure for the drill trouugh the dates are implied.
How do you have the drill trough setup?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix ,
Thanks for the reply. So, how do I pass date range as filter context since the range is defined as filter in measure's formula?
I've added all columns in drill-through in transaction data table page. I did not add measures in the drill-through.
Thanks.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
107 | |
75 | |
62 |
User | Count |
---|---|
276 | |
129 | |
124 | |
100 | |
89 |