Measures don't pass filters to a Drillthrough Page?

[Anonymous]

(My previous post was deleted! Not sure why?)
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 Measures

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),"#.##%"),
*/
 

Same happens when i have a simple , straightforward measure too !

ForecastSum = CALCULATE(SUM('FC'[ForecastSales]),'FC'[Category]="Commit")

When I right click and drillthrough, it shows all the Categories instead of just Commit
Please help or suggestion a possible alternative

[Anonymous]

(My previous post was deleted! Not sure why?)
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 Measures

[Anonymous]

Hi @Anonymous ,

Were you able to solve this issue? I am experiencing similar problem, please help!

Thanks,
Ankur

[d_gosbell]

---

@Anonymous wrote:

Same happens when i have a simple , straightforward measure too !

ForecastSum = CALCULATE(SUM('FC'[ForecastSales]),'FC'[Category]="Commit")

When I right click and drillthrough, it shows all the Categories instead of just Commit
Please help or suggestion a possible alternative

---

This is the expected behaviour. The drillthrough can only look at "externally" applied filters. It does not attempt to read inside the expression of a measure and try to figure out a possible filter context.

This is because you can have multiple, conflicting filters within a single measure

eg

Forecast Commit Ratio = DIVIDE(
 CALCULATE(SUM('FC'[ForecastSales]),'FC'[Category]="Commit")
, CALCULATE(SUM('FC'[ForecastSales]),ALL('FC'[Category]))
)

One option might be to create multiple drillthrough pages for your different measures

[d_gosbell]

Same happens when i have a simple , straightforward measure too !

ForecastSum = CALCULATE(SUM('FC'[ForecastSales]),'FC'[Category]="Commit")

[Icey]

Hi @Anonymous ,

I modified the answer yesterday, please check it out.

Best Regards,

Icey

[Icey]

Hi @Anonymous ,

I create an example and your issue did appear. 

Sum of Velo = CALCULATE ( SUM ( financials[ Sales] ), financials[Product] = "Velo" )

You need to create your measure like so:

Sum of Velo =
CALCULATE (
    SUM ( financials[ Sales] ),
    FILTER ( ALL ( financials ), financials[Product] = "Velo" )
)

With ALL function, it returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.