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"
)
Hi SKEUK
You can create a measure using the Calculate function. We can add a filter onto the column and using IN list out the items we want to return.
High rating =
Calculate(
Count(table[RatingColumn])
, table[Ratingcolumn] IN {"Catstrophic", "High"}
,table[Statuscolumn] = "Open"
)
Low rating =
Calculate( Count(table[RatingColumn])
, table[Ratingcolumn] IN {"Medium", "Low"}
,table[Statuscolumn] = "Open")
Thank you!
