Week over Week % change with Slicer capability

Anonymous — Thu, 03 Sep 2020 19:27:34 GMT

I am trying to create a waterfall chart which displays week over week % changes in inventory sliced by Customer_Name and DMA_Code. I have tried using example from previous posted solutions, but not getting what I need.

The following provides the numbers but the slicer choices all show the same values.

Using:

WoW Change =

VAR lastWeekAmount =

CALCULATE (

SUM ( INVENTORY[INVENTORY]),

FILTER (

ALL ( 'INVENTORY' ),

'INVENTORY'[Weeknum]

= MIN ( 'INVENTORY'[Weeknum] ) - 1

)

RETURN

DIVIDE ( SUM ( INVENTORY[INVENTORY] ) - lastWeekAmount, lastWeekAmount, 0 )

On this table:

Re: Week over Week % change with Slicer capability

Fowmy — Thu, 03 Sep 2020 19:37:15 GMT

Anonymous

Try

WoW Change = VAR lastWeekAmount = CALCULATE ( SUM ( INVENTORY[INVENTORY]), FILTER ( ALLSELECTED ( 'INVENTORY' ), 'INVENTORY'[Weeknum] = MIN ( 'INVENTORY'[Weeknum] ) - 1 ) ) RETURN DIVIDE ( SUM ( INVENTORY[INVENTORY] ) - lastWeekAmount, lastWeekAmount, 0 )

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube LinkedIn

topic Re: Week over Week % change with Slicer capability in DAX Commands and Tips

Week over Week % change with Slicer capability

Re: Week over Week % change with Slicer capability