excel to DAX formula

[Queen_Geek]

My data is all in columns on the same table-no relationships needed.  I need to find the % of projects that have lessons.  The screenshot is the excel version of the data output.  The excel formula is

=SUBTOTAL(9,Table1[Column1])/SUBTOTAL(3,Table1[Project]). 

How can I translate this into DAX? 

I tried this, but the % isn't correct (comes up 4.8%). 

Count of # Lessons divided by Count of Project =

DIVIDE(SUM('Table1'[# Lessons]), COUNTA('Table1'[Project]))

[v-eachen-msft]

Hi @Queen_Geek ,

After my tests, i got the same result with these formula. Maybe it is caused by your filter or slicer. You could add ALL() filter in your measure.

[Queen_Geek · Accepted solution]

I figured it out on my own.  The answer was simply  

=

DIVIDE(Counta('Table1'[Startup]), COUNTA('Table1'[Project]))

.

[amitchandak]

@Queen_Geek , Not very clear.

Refer if this can help

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

[Queen_Geek]

That doesn't help.  There are no subtotals in my data, it's in columns, like the screenshot shows.  What isn't clear?  Here is a screenshot of the data (partial) if that helps?