Drillthrough from table/matrix with multiple calculated measures using filters

[GaryWalton]

Hi,

I am currently looking into this and have found a number of other users experiencing this issue, responses pointing to a number of unweildy workarounds and no explicitly similar entries in the 'ideas' forum (so let me know if I should also post this there).

I am giving a simple example but there are many instances within my reports where the following occurs and blocks me from using the drillthough functionality 'correctly' as a report viewer percieves it.

The below visual (either table or matrix) has no filters applied to it:

Measures:

Female Terminations = CALCULATE([Total Terminations], Gender[Gender]="Female")

Total Terminations = COUNT(Terminations[Worker ID])

% Female Terminations = [Female Terminations]/[Total Terminations]

I also have a details page (the drillthrough destination) with per row information from the Terminations table.

When using [Total Terminations] as the drillthrough field, I can drill from the table on Total Terminations and see the correct number of records.

When using [Female Terminations] as the drillthrough field, I can drill from the table on Female Terminations and see the number records which correspond to Total Terminations - showing me an incorrectly filtered table based on the number from which I drilled.

Whilst investigating other tickets, it appears that the drillthrough functionality completely ignores filters used in measures even when those measures are specifically chosen by the report author as the drillthough field.

In this example, the only way to drill to the Female Terminations is to present the table / matrix visual with a pre-applied filter on [Gender], which results in the following:

Do you know of a solid working method on how I can drillthrough to see a 'subset' of information in the same vein as the Female / Total problem that can be applied to any instance where both figures are shown in the same visual.

Also, feedback if the ability for drillthrough to acknowledge / utilise filters used in calculated measures should be added to the 'ideas' forum.

Thanks,

Gary. 

[v-deddai1-msft · Accepted solution]

Hi @GaryWalton ,

The filter inside the measure will not be pass. Only filters from the report itself can be passed, i.e. fields in the visual itself, slicers, other filters.

As a workaround, please refer to https://blog.crossjoin.co.uk/2018/12/21/power-bi-drillthrough-complex-measures/

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

Best Regards,

Dedmon Dai

[amitchandak]

@GaryWalton , Drill through will not pass measure filters