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"...
Need Help
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!!