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
    4 years ago

    Hi Anonymous 

     

    Try this measure:

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

     

    Jing

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I'm sorry my friends for the bad explanation.
v-jingzhang  and daxer-almighty 

Currently I have the following situation with the number of the month the percentage of the month and how many times it has run annually.
in this column that ran annually I only count the running status = 1.

When I put the Month Number filter, it separates by month and I need the total amount, in this case 424 and not the amount per month.

hosts is my table
Percent Per Month = ((hosts[2]*100)/424)/100 (this value in bold is what I need to make a formula to always appear it)

Running Year = CALCULATE(COUNTROWS(hosts),hosts[status]=1)

I need to get the total running value regardless if period or date filter is selected.


I believe that by assembling this image below it would work.

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi Anonymous 

     

    Try this measure:

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

     

    Jing