Power Bi Formula Not Working

[Excel Fox]

Hi

I Have columns in a table that all contain Y and want to sum them up and then divide both other Y columns.

So to be clear the equation would be Number of Y in Column a divided by number of Y in column C. I've tried Sum/ Calculate/ Counta but all are failing.

The aim is to then drop the calculation into a graph to attach a target line to it. I have also tried conditional columns but no success as they count the blanks as N which throughs the final figure out.

Open to any ideas.

 

[Misca]

In Power BI the easiest way to get the count of something is using the COUNTROWS function on your data table. If you want to count the number of Ys in a column A try

COUNTROWS(FILTER(Table1,Table1[Column A]="Y"))

If you want to count the number of rows in a column that are not blank try something like:

COUNTROWS(FILTER(Table1,Table1[Column A]<>BLANK()))

Another way to get the count the nonblank rows would be using the COUNTAX formula:

COUNTAX(Table1,Table1[Column A])