Formatting dashboard with multiple filters

Hi  Anonymous ,

You can try the following dax:

Bulk =
VAR _7day =
    TODAY () - 7
VAR _30day =
    TODAY () - 30
VAR _365day =
    TODAY () - 365
RETURN
    SWITCH (
        TRUE (),
        MAX ( 'Table'[Value] ) = "7Day",
            SUMX (
                FILTER (
                    ALL ( 'Table1' ),
                    'Table1'[Site] = MAX ( 'Table'[Site] )
                        && 'Table1'[Date] > _7day
                        && 'Table1'[Type] = "Apple"
                        && 'Table1'[Bulk] <> "False"
                ),
                [Sales]
            ),
        MAX ( 'Table'[Value] ) = "30Day",
            SUMX (
                FILTER (
                    ALL ( 'Table1' ),
                    'Table1'[Site] = MAX ( 'Table'[Site] )
                        && 'Table1'[Date] > _30day
                        && 'Table1'[Type] = "Apple"
                        && 'Table1'[Bulk] <> "False"
                ),
                [Sales]
            ),
        MAX ( 'Table'[Value] ) = "365Day",
            SUMX (
                FILTER (
                    ALL ( 'Table1' ),
                    'Table1'[Site] = MAX ( 'Table'[Site] )
                        && 'Table1'[Date] > _365day
                        && 'Table1'[Type] = "Apple"
                        && 'Table1'[Bulk] <> "False"
                ),
                [Sales]
            )
    )

Bulk_Goal =
VAR _7day =
    TODAY () - 7
VAR _30day =
    TODAY () - 30
VAR _365day =
    TODAY () - 365
VAR _switch =
    SWITCH (
        TRUE (),
        MAX ( 'Table'[Value] ) = "7Day", 7,
        MAX ( 'Table'[Value] ) = "30Day", 30,
        MAX ( 'Table'[Value] ) = "365Day", 365
    )
RETURN
    IF (
        MAX ( 'Table'[Site] ) = 1,
        _switch,
        SUMX (
            FILTER ( ALL ( 'Table2' ), 'Table2'[Site] = MAX ( 'Table'[Site] ) ),
            [Bulk_goal]
        ) * _switch
    )

Bulk_Diff =
[Bulk] - [Bulk_Goal]

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.