Forum Discussion

AndreaBracco's avatar
AndreaBracco
Regular Visitor
1 year ago
Solved

Problems with row/filter context

Hi all, I am quite new to Power BI and I have the following issue. I have the following visual, where the column "Check_Global" is actually a measure. The measure is computed as follows.   ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    I am not sure how your semantic model looks like, but please try something like below whether it works.

    Check_Global =
SUMX (
    VALUES ( calendar_table[date_column] ),
    CALCULATE (
        IF (
            OR (
                SUMX ( 'CHP Units', 'CHP Units'[Check_Hours] ) > 0,
                SUMX ( 'CHP Units', 'CHP Units'[Check_EE] ) > 0
            ),
            1,
            BLANK ()
        )
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
1 year ago

Hi,

I am not sure how your semantic model looks like, but please try something like below whether it works.

Check_Global =
SUMX (
    VALUES ( calendar_table[date_column] ),
    CALCULATE (
        IF (
            OR (
                SUMX ( 'CHP Units', 'CHP Units'[Check_Hours] ) > 0,
                SUMX ( 'CHP Units', 'CHP Units'[Check_EE] ) > 0
            ),
            1,
            BLANK ()
        )
    )
)
  • AndreaBracco's avatar
    AndreaBracco
    Regular Visitor
    1 year ago

    Hi, it worked perfectly. Thank you