Forum Discussion

Fxelixe's avatar
Fxelixe
Frequent Visitor
3 years ago
Solved

IF statement not adding on Category Level

Hello,   So I got some issue on applying my measure on higher levelv of category. Here's my data set:   Group ID X Y Z Have X Y Z A A01 10000 10000 10000 1 A A02 1...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

     

     

     

    Desired outcome measure: =
SUMX (
    ADDCOLUMNS (
        DISTINCT ( 'Group'[ID] ),
        "@condition",
            IF (
                COUNTROWS (
                    CALCULATETABLE (
                        FILTER ( 'Value', 'Value'[Sales] <> 0 ),
                        'Time'[Month] = "Nov"
                    )
                ) = 3,
                1
            )
    ),
    [@condition]
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

 

 

 

 

Desired outcome measure: =
SUMX (
    ADDCOLUMNS (
        DISTINCT ( 'Group'[ID] ),
        "@condition",
            IF (
                COUNTROWS (
                    CALCULATETABLE (
                        FILTER ( 'Value', 'Value'[Sales] <> 0 ),
                        'Time'[Month] = "Nov"
                    )
                ) = 3,
                1
            )
    ),
    [@condition]
)

 

Fxelixe's avatar
Fxelixe
Frequent Visitor
3 years ago

Thank you for the inspiration. hope this also can help others.