Need a Power BI equivalent for an excel formula

[Anonymous]

Hi,

Need a Power BI equivalent for the below formula and how do I proceed building this in Power BI.

=COUNTIFS($G:$G,$A$1,ACB:ACB,"4 - Very Important")

Thanks,

[V-pazhen-msft · Accepted solution]

Hi, @Anonymous 

DAX do not support COUNTIF function. Instead, you could use:

CALCULATE (COUNTA(column A), FILTER('Table1'[column A]= xxx), [column B]="4 - Very Important"

You use FILTER instead of IF criteria in Excel: https://docs.microsoft.com/en-us/dax/filter-function-dax 

If you want the exact equivalent formula, please provide the data sheet if possible and information about your expected result.

Best, 
Paul

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.