WHY? Measures don't pass filters to a Drillthrough Page?

[Anonymous]

I just found out that the Filters set inside a Measure does not get passed to a Drillthrough page. Only filters from Visuals do!
I am in shock to know that my entire report will lose the "Drill-through" functionality due to this limitation! 😞

Isnt that how Cross Filter works on Power BI, why not in DrillThrough? Some one please tell me my whole understanding is wrong?

Here is my table with Categories coming from a Static Table (contains possible Metric desc for matrix: Commit, Upside, etc) , I have regions on Column

The matrix values varies basic on each category displayed here (shows either Sum or Percentage)

Here is a shorter version of my Measure. As you can see each category has a different calculation and filter set. When I try to Drillthrough, only Visual 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),"#.##%"),
*/
 

[v-eachen-msft]

Hi @Anonymous ,

Please kindly refer to the similar solved post:

https://community.powerbi.com/t5/Desktop/Drill-Through-Doesn-t-Pass-Measure-Filters-Workaround/td-p/...

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.

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.

[Anonymous]

Thank you @v-eachen-msft 

I will go through the article. But these are all work arounds! 😞

Is there a way this feature can be added to Power BI by default? Arent't the Filters for each cell of a Matrix/Table already available?
Could the development team look into this feature?

[v-eachen-msft]

Hi @Anonymous ,

Yes, you could come up a new idea about that and add your comments here to improve Power BI and make this feature coming sooner.