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 ()
        )
    )
)
quantumudit's avatar
quantumudit
Super User
1 year ago

Hello AndreaBracco 

Could you please provide sample data that fully represents your issue or question in a usable format, rather than a screenshot? Ensure the dataset is anonymized and does not contain any sensitive or unrelated information.

 

Additionally, it would be very helpful if you could share the expected outcome based on the provided data - this can be in any format, including a screenshot. Having a clear reference for comparison will significantly improve the chances of getting the correct solution in the first response.

 

For best practices, you may find the following links useful:

 

Thanks,
Udit

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

Proud to be a Super User