Forum Discussion

equevedo84's avatar
equevedo84
Frequent Visitor
2 years ago
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...
Need Help
  • HotChilli's avatar
    HotChilli
    2 years ago

    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

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

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

  • equevedo84's avatar
    equevedo84
    Frequent Visitor
    2 years ago

    Thank you very much for your response.  I tried to post the data sample as an attachment but could not find a button or option for file attachment.

  • equevedo84's avatar
    equevedo84
    Frequent Visitor
    2 years ago

    Worked just like I wanted it, thanks!