Forum Discussion
Solved
Measure two columns
Hello all, Apologies, I am incredibly new to Power BI and am working on a very basic model and I am currently stuck. I have a risk register spreadsheet with a description of the risk, the sta...
Almost it looks like you are missing a column name in filter bit and to only show the open items:
High rating = CALCULATE(
COUNT('Risk Register 2025'[Status])
,'Risk Register 2025'[RatingColumn] IN {"Catastrophic", "High"}
,'Risk Register 2025'[Status] = "Open"
)
So would it be like this?
High rating = CALCULATE(
COUNT('Risk Register 2025'[Status])
,'Risk Register 2025' IN {"Catastrophic", "High"}
)
I get the message 'The syntax for High is incorrect
- SamWiseOwl
Super User
Almost it looks like you are missing a column name in filter bit and to only show the open items:
High rating = CALCULATE(
COUNT('Risk Register 2025'[Status])
,'Risk Register 2025'[RatingColumn] IN {"Catastrophic", "High"}
,'Risk Register 2025'[Status] = "Open"
)