Percent of Change on total measure

[lkhall]

While I feel like this should be simple I am stuggling to come up with the appropriate DAX to calculate Week over Week percent of change. For the below matrix I want to be able to show the % of change week over week for the total patient count. Any guidance would be greatly appreciated. 

[Anonymous · Accepted solution]

Hi  @lkhall ,

Here are the steps you can follow：

1. Create calculated column.

week = WEEKNUM('Table'[Date],2)

2. Create measure.

Measure =
var _current=
SUMX(
    FILTER(ALL('Table'),'Table'[Group]=MAX('Table'[Group])&&'Table'[week]=MAX('Table'[week])),[Value])
var _next=
SUMX(
FILTER(ALL('Table'),'Table'[Group]=MAX('Table'[Group])&&'Table'[week]=MAX('Table'[week])+1),[Value])
return
DIVIDE(
    _next,_current)

Measure 2 =
var _table=SUMMARIZE('Table','Table'[Group],"Value",[Measure])
return
IF(
    HASONEVALUE('Table'[Group]),
    [Measure],SUMX(_table,[Value]))

3. Result:

Best Regards,

Liu Yang

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