Count formula in POwer Pivot

[TicaTorch1]

I need a COUNT formula in powerpivot. I have a column that contains women owned that contain NO and 100%. I need a count of the 100%. I have a table called Loan List and the column is Women Owned. Thank you

 

[TicaTorch1]

This formula isn't working
Women Owned:=COUNT([LoanID],[WomenOwned])="100"

 

[bkjohn2016]

Try using two formulas:

TOTAL LOAN COUNT:=COUNTROWS(LoanList)

WOMEN OWNED LOAN COUNT:=CALCULATE([TOTAL LOAN COUNT],FILTER(LoanList,LoanList[WOMEN OWNED]="100"))

 

[TicaTorch1]

Thank you so much... I still get an error
Women Owned Loan Count:=CALCULATE([Total Loan Count],FILTER('Loan List'[WomenOwned]="100%"))
Is the % causing the error? The only characters in the column is "No" and "100%"

 

[TicaTorch1]

I found my problem. Thank you!