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

HoangHugo  Hello,

 

Thanks for the reply. No its not working.

 

When I turned that one to a table,

 

 

What could be the issue for this? The total value need to be populated in every row. 

 

  • 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.. 😞