Forum Discussion
Solved
excel to DAX formula
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 i...
I figured it out on my own. The answer was simply
=DIVIDE(Counta('Table1'[Startup]), COUNTA('Table1'[Project])).
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.
I figured it out on my own. The answer was simply
=
DIVIDE(Counta('Table1'[Startup]), COUNTA('Table1'[Project]))
.