Forum Discussion

SriGaG1's avatar
SriGaG1
Icon for Helper II rankHelper II
4 years ago
Solved

Average Constant line creation is not working

I have created a line graph which is filtered using a date range picker. . And the chart is getting dynamially changed when we are back dating the values. Aditionally I needed an average value for La...
data protection
Need Help
Show and Tell
Tips and Tricks
  • HoangHugo's avatar
    HoangHugo
    4 years ago

    Hi

    I think it is due to use ALL function, that will clear all Date filter in your whole page. So, try this one

    Avg sales = CALCULATE( IFERROR(
    [LY Sales]/[Measurecal],
    BLANK()
    ), ALLSELECTED('Date'[Date]))

SriGaG1's avatar
SriGaG1
Icon for Helper II rankHelper II
4 years ago

Hello HoangHugo 

 

Thankyou.

But this is what I get. 

Avg sales = CALCULATE( IFERROR(
    [LY Sales]/[Measurecal],
    BLANK()
    ),ALLSELECTED('Date'[Date]))
 

Why this kind of things happennig?

SriGaG1's avatar
SriGaG1
Icon for Helper II rankHelper II
4 years ago

HoangHugo  Hope you didnt make any otherchange.. 😞