Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate variance with dates not within page filter range

Hi   Below is a sample of a report which I have created in Power BI. The monthly files for this report are uploaded onto one folder stored in the sharepoint and  combined into one dataset which ser...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

    Try Allselected() like below.

    Impairment_Variance =
VAR ImpairmentDec2018 = Calculate(
    sum('AU Trade Loan Data'[Impairment for Graph]),
    allselected(),
    'AU Trade Loan Data'[Source.Name]="2018-12-AU_Monthly_Reporting.xlsx"
)
VAR Impairment_SelectedMonth = sum('AU Trade Loan Data'[Impairment for Graph])
Return
if(isblank(Impairment_SelectedMonth)=TRUE,0,Divide (Impairment_SelectedMonth,ImpairmentDec2018)-1)
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous 

Have you tried the code I gave you?

Many Thanks

Mariusz

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Mariusz , yes, I have tried it but the denominator returned for Dec 2018 is not right. It takes the sum of everything even after filters are applied. I need it to be dynamic as the users apply the necessary filters.