Forum Discussion

Moustapha1's avatar
Moustapha1
Frequent Visitor
8 years ago

Power BI Desktop (Report Level Filter)

Hello everyone,


I have a serious problem: /
How can I get my CA_Year_N static even when I filter on the "Month report filter" ??
I don't want to go through the "modification of interactions" between the graphics because my filter is for all the report.
Is this manipulation possible with Power BI or DAX?

Thank you in advance.

Need Help

2 Replies

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

    Hi Moustapha1,

     

    Maybe you could use ALLSELECTED function for the measure formula to ignore the filter selection. Please show us the formula of "CA_Year_N".

     

    Regards,

    Yuliana Gu

    • Moustapha1's avatar
      Moustapha1
      Frequent Visitor
      8 years ago

      Hi v-yulgu-msft,

      Thank you for your answer.
      My CA_Year_N is defined as this, a simple calculation:

      CA_Year_N = SUM (Table1 [amount]).
      But I tried other formulas like:
      CA_Year_N = CALCULATE ([CA_Year_N] FILTER (ALL (DimDate [Date]. [Month]); DimDate [Date]. [Month] <= MAX (DimDate [Date]. [Month])))

      or

      CA_Year_NTest = CALCULATE ([CA_Year_N] ALL (DimDate [Date]; DimDate [Year]))

       

      But the result is always the same.

      The report level filter has the upper hand on all.

      Thank you!!