Summarize after user filter condition

[fabio_garcia85]

Hi!

I have a column for calculating percentage (Amount of errors divided by the amount of requests) per day. This table is one line per day. Image below:

When I show this percentage per day, the calculation is ok, however, when I need to summarize this amount per month, PowerBI is making a sum of the day percentages. I wanted it to recalculate the percentage making a sum of the amount of errors in the month and dividing by the amount of requests in the month (value of the columns below), but I'm not able to do this logic. Could you help me please guys?

[dedelman_clng · Accepted solution]

Hi @fabio_garcia85 -

Don't calculate the percentage as a column. Change it to a measure and it should give you the right answer at all levels. You can add the measure as a column to a table or matrix visual and if you are showing individual rows it will act exactly like a column.

Example:

ErrorPercentage = 
  DIVIDE(SUM(Error), SUM(Total), 0)

Hope this helps

David