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.
Hi,
In my report I use some measures with filter context in the dax code, for example:
Solved! Go to Solution.
Hi Leon,
When using drillthrough, filters created within a measure with CALCULATE are not passed to the drillthrough page.
Only filters from the report itself can be passed, i.e. fields in the visual itself, slicers, other filters.
I agree that this makes it confusing when drilling through from a measure like Count Orchid Cut.
This post discusses the same issue and proposes a solution by using a measure on the drillthrough page that replicates the filter on the original visual.
In your case, it sounds like you have a table or similar visual on the drillthrough page. You could add a visual level filter to that visual with a slightly modified measure set to is not blank:
Count Orchid Cut = CALCULATE ( COUNT ( VarietyTable[VarietyId] ); KEEPFILTERS ( VarietyTable[Crop] = "Orchid Cut" ) )
By the way, do you have multiple measures of a similar nature that all need to drillthrough?
Regards,
Owen
Hi Leon,
When using drillthrough, filters created within a measure with CALCULATE are not passed to the drillthrough page.
Only filters from the report itself can be passed, i.e. fields in the visual itself, slicers, other filters.
I agree that this makes it confusing when drilling through from a measure like Count Orchid Cut.
This post discusses the same issue and proposes a solution by using a measure on the drillthrough page that replicates the filter on the original visual.
In your case, it sounds like you have a table or similar visual on the drillthrough page. You could add a visual level filter to that visual with a slightly modified measure set to is not blank:
Count Orchid Cut = CALCULATE ( COUNT ( VarietyTable[VarietyId] ); KEEPFILTERS ( VarietyTable[Crop] = "Orchid Cut" ) )
By the way, do you have multiple measures of a similar nature that all need to drillthrough?
Regards,
Owen
I have a similar setup too and wish Drillthrough passed Filters from Measures too. Isnt that how Cross Filter works? I am was in shock to know that my entire report will lose the "Drill through" functionality due to this limitation! 😞
Here is my table with Categories coming from a Static Table (Commit, Upside, etc) , I have regions on Column
The matrix values varies basic on each category displayed here
Here is a shorter version of my Measure. As you can see each category has a different filter. When I try to Drillthrough, only matrix filters are passed , not the Filters applied in the Measurs. Same happens when i have a simple , straightforward measure too! Please help or suggestion a possible alternative
CategoryMetrics =
var vCommit= CALCULATE([ForecastSales],'FC'[forecast category]="Commit")
var vUpside= CALCULATE([ForecastSales],'FC'[forecast category]="Pipeline")
var vEarly =CALCULATE([ForecastSales],left('FC'[sales stage],2) in {"X0","X2","X3"})
var vLate =CALCULATE([ForecastSales],left('FC'[sales stage],2) in {"X4","X5"})
return
SWITCH(SELECTEDVALUE('Category'[ID]),
1, format(vCommit,"$ #.00 M"),
2,format(vUpside,"$ #.00 M"),
3, format(vEarly,"$ #.00 M"),
4, FORMAT(vLate,"$ #.00 M"),
0)
/* Calculate Percentages
5,FORMAT(DIVIDE(vCommitPerc,vCommit),"#.##%"), 5,FORMAT(DIVIDE(vCommitPerc,vCommit),"#.##%")
6, FORMAT(DIVIDE(vUpsidePerc,vUpside) ,"#.##%"),
7,FORMAT(DIVIDE(vLatePerc,vLate),"#.##%"),
*/
Hi Owen, thanks for your answer. Indeed I have multiple measures that all need to drillthrough.
Regards, Leon
@LBE Did you get this to work for multiple measures? So far, the only way I've been able to get it to work is to do a different drill-through page for each variation, but that seems excessive to me. I feel like there has to be a more elegant way to do this!
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 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |