Forum Discussion

PierreCouratier's avatar
PierreCouratier
New Member
8 years ago
Solved

How can I reuse filter?

Hi,

 

I have a complex measure like:

Sum Value = CALCULATE( sum('Data'[Value]); [Complex filter...] )

 

I've many measures using the same complex filter.

Is it possible to reuse this complex filter for many measures?

 

Thanks for your help

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi PierreCouratier,

     

    I'm afraid it is not available to reuse the same complex filter in multiple measures. But in some aspects, you can split some calculations used in the complex filter and make them separate measures so that you can directly refer to measure name when you write the complext filter next time.

     

    Regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi PierreCouratier,

     

    I'm afraid it is not available to reuse the same complex filter in multiple measures. But in some aspects, you can split some calculations used in the complex filter and make them separate measures so that you can directly refer to measure name when you write the complext filter next time.

     

    Regards,

    Yuliana Gu