Excels' Countif measurement with division in DAX form?

[SereneSea]

Evening (or morning) everyone!?

I am having troubles creating a measurement with DAX function. I have a column "% Progress" and I want to count all the "100%" then divide it by the number of rows to get "Total Complete" in percentage.
My excel formula is below and I would like it translated into DAX.

=(COUNTIF(Table[% Progress],"100%"))/(COUNTA(Table[% Progress]))

I hope one of you wizards can help me!?

 

[severynm]

Hi!

Try a measure like

=CALCULATE(COUNT(Table[% Progress]),Table[% Progress]=100) / COUNT(Table[% Progress])

, making sure to substitute in the correct table name for the one you are using. We can use CALCULATE to filter down the table to the criteria we want, then count the number of remaining rows.