Forum Discussion

majo23's avatar
majo23
Frequent Visitor
3 years ago
Solved

Average rate calculation

  Hi everyone, I want to get the average of the percentage that I calculate in a measure I made 3 measures,   Count HBRA = CALCULATE ( COUNTA ( 'table1'[Span HBRA] ) ) Count HBRA inspection...
Need Help
  • danextian's avatar
    danextian
    3 years ago

    Hi majo23 ,

     

    You can use SUMMARIZE to create a virtual summary table and AVERAGEX to get the average. Assuming that granularity is based on Feeder column, try the measure below. 

    =
AVERAGEX ( SUMMARIZE ( datatable, datatable[Feeder], "HBRA", [HBRA] ), HBRA )

    Change the table and column names accordingly.

     

danextian's avatar
danextian
Super User
3 years ago

Hi majo23 ,

 

You can use SUMMARIZE to create a virtual summary table and AVERAGEX to get the average. Assuming that granularity is based on Feeder column, try the measure below. 

=
AVERAGEX ( SUMMARIZE ( datatable, datatable[Feeder], "HBRA", [HBRA] ), HBRA )

Change the table and column names accordingly.

 

majo23's avatar
majo23
Frequent Visitor
3 years ago

Thanks for the reply danextian, I was thinking about a simple measure instend of making a table but is a solution, thanks! have a good day 🙂