Excel Function in DAX

[Anonymous]

Hi !

Can you help me to get DAX formula right?

I have this excel formula which calculates frequency% & Occupancy% .I want to write in DAX.

In Excel=COUNTIF(E54:EX54,">.01")/COUNT(E$53:EX$53)

In Excel =IFERROR((SUM(E54:EX54))/EY183,0)

Regards,

[v-lili6-msft]

hi, @Anonymous 

This simple logic is calculated by rows, there is no function could be used by this.

What is your data structure in power bi, could you share a simple pbix file and expected output, we could give you a workaround.

Best Regards,

Lin