Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Use COUNT functions over rows

Hey,

 

I can not wrap my head around on how to put the following Excel Formula in Power BI. The goal is to perform this calculation for each row in the Table (#rows =~200).

 

(COUNTBLANK(C2:GT2)/(COUNTA(C2:GT2)+COUNTBLANK(C2:GT2)-COUNTIF(C2:GT2;"N/A")))*100

 

Need Help

6 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    Can you share a sample of your data and how it organized? is it in columns or rows in Power BI ?


    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      It is in columns in Power BI, I have tried to pivot the columns but to no avail. This is the data set and expected outcome I am working with: Dataset Link