Forum Discussion

Queen_Geek's avatar
Queen_Geek
Icon for Helper I rankHelper I
6 years ago
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...
Need Help
  • Queen_Geek's avatar
    Queen_Geek
    6 years ago

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

     
    =

    DIVIDE(Counta('Table1'[Startup]), COUNTA('Table1'[Project]))
     
    .
Queen_Geek's avatar
Queen_Geek
Icon for Helper I rankHelper I
6 years ago

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?