Forum Discussion

PiyushBQ's avatar
PiyushBQ
Icon for Helper I rankHelper I
6 years ago
Solved

Average After Slicer Input

Hi, I have this dataset Sector Item Value Average (calculate) Rank (calculate) Gold E 89 66.6 1 Gold C 82 66.6 2 Gold D 69 66.6 3 Gold B 51 66.6 4 Gold ...
Need Help
Show and Tell
Tips and Tricks
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi PiyushBQ ,

     

    Try create measure like this:

    Measure = CALCULATE(AVERAGE('Table'[Value]),ALLSELECTED('Table'))

    Or calculated column:

    Column = CALCULATE(AVERAGE('Table'[Value]),ALLEXCEPT('Table','Table'[Sector]))

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PiyushBQ's avatar
PiyushBQ
Icon for Helper I rankHelper I
6 years ago

Thank you for taking the time out parry2k .

I tried doing it but it didn't work. Please check the screenshot.

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

PiyushBQ are you adding this as a measure or column?

  • PiyushBQ's avatar
    PiyushBQ
    Icon for Helper I rankHelper I
    6 years ago

    Hi parry2k I had previously written it as a measure. 

    But adding it as a column was fraught with problems too. Here's a screenshot of the error when added as a column.

     

     

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi PiyushBQ ,

       

      Try create measure like this:

      Measure = CALCULATE(AVERAGE('Table'[Value]),ALLSELECTED('Table'))

      Or calculated column:

      Column = CALCULATE(AVERAGE('Table'[Value]),ALLEXCEPT('Table','Table'[Sector]))

       

      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.