Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Percentage per Month

calculation does not match. I am using the following formula as a measure in both views.   1 = DIVIDE(sum(hosts[cpuUtilization]),CALCULATE(sum(hosts[cpuUtilization]),ALLEXCEPT(hosts,hosts[Mes]) )...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    Try this measure:

    Total = CALCULATE ( COUNTROWS ( hosts ), ALL ( hosts ), hosts[status] = 1 )

     

    Jing