Cumulative sum with a slicer

[FilipFireFlyBI]

Hi all,

I have a slicer (A) with the ProductID datetype number.

When I select productID 3 I want to see the cumulative sum of all productIDs (so ID 1 2 3) (B)

However, I only see productID 3 (The cumulative value 35K is correct).

In other words: I want to see 3 Product IDs 1,2 and 3 with their cumulative value (not ProductID 4 and the rest)

How to do this? 

Link to PBIX file on dropbox 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

I tried to use disconnected slicer table like below.

Expected outcome measure: =
IF (
    MAX ( 'dim Products'[ProductID] ) <= MAX ( 'Product ID Slicer'[ProductID] ),
    CALCULATE (
        [Gross sales],
        'dim Products'[ProductID] <= MAX ( 'dim Products'[ProductID] )
    )
)