Use COUNT functions over rows

[Anonymous]

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

[Fowmy]

@Anonymous 

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

[Anonymous]

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 

[Ashish_Mathur · Accepted solution]

Hi,

You may download the PBI file from here.

Hope this helps.

[Anonymous]

Thanks that worked. I had tried this solution before but apparently my data model was not set correctly to receive the expected outcome.

[Ashish_Mathur]

You are welcome.

[ryan_mayu]

@Anonymous 

please see the attachment below. hopt it's helpful.