Power BI Desktop (Report Level Filter)

[Moustapha1]

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.

[v-yulgu-msft]

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]

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!!