Pass the filters of a DAX measure in drillthrough

[vivien57]

Hello Everyone,

First of all thank you for reading me and your future help.

I have a problem that i can not solve for a few days.

A measure :

LastTurnoverVAT = CALCULATE(SUM('DM Billing'[TurnoverVAT]);FILTER(ALL('DIM Snapshot Date'); 'DIM Snapshot Date'[LastDayOfMonth] = MAX('DIM Snapshot Date'[LastDayOfMonth]));FILTER('DM Billing';'DM Billing'[AccountingDocumentType] = "FAC" || 'DM Billing'[AccountingDocumentType] = "AVO"))

How to make the drillthrough automaticaly take the filter "FAC" and "AVO" for AccountingDocumentType field ?

Thank for advance,

Vivien

[Anonymous]

Hi @vivien57 ,

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

Thanks,

Ankur

[v-yulgu-msft]

Hi @vivien57,

Which field did you add to DrillThrough? Please provide more description about "make the drillthrough automaticaly take the filter "FAC" and "AVO" for AccountingDocumentType field". Please illustrate your requirement with some sample data.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu

[vivien57]

Hello,

First of all thank you for your return. The LastTurnoverVAT measure I use it in the funnel visual on a main tab.

In the drillthrough (other tab) I inserted several fields. One of these fields is [AccountingDocumentType].

When I right click, then drillthrough on this measure (in the funnel), I would like the FAC and AVO values ​​to be passed to the [AccountingDocumentType] filter on the drillthrough tab.

Currently, it does not work. In the drillthrough tab, the [AccountingDocumentType] filter remains at all. The drillthrough tab does not retrieve the value of the AVO and FAC filters made in DAX in the LastTurnoverVAT measure.

Thank you in advance for your help,

Vivien