Forum Discussion
Solved
Recreating COUNTIF formula into Measure in Power BI
Hey everyone, I'm transitioning an Excel report into Power BI and want to adapt a COUNTIFS formula in the Excel report into a Power BI measure. The current COUNTIFS formula reads as follows: =CO...
Substitute your own column/table names. This is a calculated column.
ColumnNonCompliant = var _Payer = TableT[Column1] var _Prov = TableT[Column2] var _Meas = TableT[Column3] var _stat = TableT[Status] RETURN COUNTROWS(FILTER(TableT, TableT[Column1] = _Payer && TableT[Column2] = _Prov && TableT[Column3] = _Meas && TableT[Status] = "Compliant"))Post your data next time please, not a picture
You will get a quicker answer if you post a small, fake data sample and show the desired result.
