Can someone figure out what is wrong with my code?

[Ilias_PAB]

Can someone figure out what is wrong with my code?

Purpose of the code:

If the column Brand is filtered and SKU is not --> value sales of 2022 of the whole brand with all SKUs
If  the column SKU is filtered  --> value sales of 2022 of a specific SKU

If no filters --> value sales of 2022 of all the brands & all the SKUs

Total Sales 2022 III =

VAR SelectedBrand = SELECTEDVALUE('DATA'[Brand])

VAR SelectedSKU = SELECTEDVALUE('DATA'[SKU])

RETURN

CALCULATE(

    IF(

        ISFILTERED('DATA'[Brand]) && ISFILTERED('DATA'[SKU]),

        SUM('DATA'[Sales (€)])),

        IF(

            ISFILTERED('DATA'[Brand]),

            CALCULATE(

                SUM('DATA'[Sales (€)])),

                FILTER(

                    ALL('DATA'),

                    YEAR('DATA'[Time period]) = 2022 &&

                    'DATA'[Brand] = SelectedBrand

                )

            ),

            IF(

                ISFILTERED('DATA'[SKU]),

                CALCULATE(

                    SUM('DATA'[Sales (€)])),

                    FILTER(

                        ALL('DATA'),

                        YEAR('DATA'[Time period]) = 2022 &&

                        'DATA'[SKU] = SelectedSKU

                    )

                ),

                CALCULATE(

                    SUM(DATA[Sales (€)])),

                    FILTER(

                        ALL('DATA'),

                        YEAR('DATA'[Time period]) = 2022

                    )

                )

[v-yangliu-msft · Accepted solution]

Hi  @Ilias_PAB ,

I created some data:

You can use the following dax：

Total Sales 2022 III =
VAR SelectedBrand = SELECTEDVALUE('DATA'[Brand])
VAR SelectedSKU = SELECTEDVALUE('DATA'[SKU])
return
IF(
    ISFILTERED('DATA'[Brand])&&NOT(ISFILTERED('DATA'[SKU])),
    SUMX(
        FILTER(ALL('DATA'),
        'DATA'[Brand]=SelectedBrand &&'DATA'[Time period]=2022),[Sales (€)])
    ,
IF(
    ISFILTERED('DATA'[SKU]),
      SUMX(
       FILTER(ALL('DATA'),
      'DATA'[Time period]=2022&&'DATA'[SKU]=SelectedSKU),[Sales (€)])
    ,
IF(
    NOT(ISFILTERED('DATA'[Brand]))&&NOT(ISFILTERED('DATA'[SKU])),
         SUMX(
        FILTER(ALL('DATA'),
     'DATA'[Time period]=2022),[Sales (€)])
)))

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.