ACR Report Compare Snap Shots

Hi, martipe1 
Thank you for your response.

1.Firstly, the reason for creating a new table as a slicer is that if you use the current table directly as a slicer, it will restrict the data displayed to only those selected by the slicer. This approach does not allow for the requirement of selecting a date while displaying both the current date and the selected date.

2.Secondly, based on your updated data structure, you might consider replacing the use of visual calculations with the following measures:

Variance1 =
FORMAT (
    DIVIDE (
        SUM ( 'Table'[0-30] ),
        CALCULATE (
            SUM ( 'Table'[0-30] ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[SnapShot/Days Past Due]
                    = MAX ( 'Table'[SnapShot/Days Past Due] ) - 1
            )
        )
    ),
    "0.00%"
)

Variance2 = 
FORMAT (
    DIVIDE (
        SUM ( 'Table'[31-60] ),
        CALCULATE (
            SUM ( 'Table'[31-60] ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[SnapShot/Days Past Due]
                    = MAX ( 'Table'[SnapShot/Days Past Due] ) - 1
            )
        )
    ),
    "0.00%"
)

Variance3 = 
FORMAT (
    DIVIDE (
        SUM ( 'Table'[61-90] ),
        CALCULATE (
            SUM ( 'Table'[61-90] ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[SnapShot/Days Past Due]
                    = MAX ( 'Table'[SnapShot/Days Past Due] ) - 1
            )
        )
    ),
    "0.00%"
)

Please note that you will need to create a measure for each column due to the visible limitations.

3.Here's my final result, which I hope meets your requirements.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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