Forum Discussion

fabio_garcia85's avatar
fabio_garcia85
Regular Visitor
5 years ago
Solved

Summarize after user filter condition

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's avatar
    dedelman_clng
    5 years ago

    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

1 Reply

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    5 years ago

    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