Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Chart Context and Normalization

Hello, I have run up against an issue Youtube/Google University has not helped me solve yet.  Many have gotten me close, but none have given the final desired result.    I have a chart with multipl...
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

    Try this:

    Measure = 
var _firstValue=
CALCULATE(
    SUM('Table'[Sales]),ALL('Table'),
    'Table'[Date]=MINX(ALL('Table'),[Date])
    )
var _currentSale=MAX('Table'[Sales])
return DIVIDE(_currentSale,_firstValue)-1

    Result:

     

    Please refer to the attachment below for details.

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

     

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

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, Anonymous 

Try this:

Measure = 
var _firstValue=
CALCULATE(
    SUM('Table'[Sales]),ALL('Table'),
    'Table'[Date]=MINX(ALL('Table'),[Date])
    )
var _currentSale=MAX('Table'[Sales])
return DIVIDE(_currentSale,_firstValue)-1

Result:

 

Please refer to the attachment below for details.

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng

 

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