Forum Discussion

damit23183's avatar
damit23183
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Average of Percentage Column

              Hi,   I would like one help to calcualte average of Health% column as you can see above. Health% column is Measure i have created based on logic. I need to calcualte Aver...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    So, what you want to do is to create a table variable that is the same as your visual displayed and then do an AVERAGEX across it. So let's say that you have a table with exactly the columns you have in your visual minus your measure, you would do this:

     

    Average of Measure =
  VAR __Table = 
    ADDCOLUMNS(
      'Table',
      "__Health %",[Health %]
    )
RETURN
  AVERAGEX(__Table,[__Health %])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

So, what you want to do is to create a table variable that is the same as your visual displayed and then do an AVERAGEX across it. So let's say that you have a table with exactly the columns you have in your visual minus your measure, you would do this:

 

Average of Measure =
  VAR __Table = 
    ADDCOLUMNS(
      'Table',
      "__Health %",[Health %]
    )
RETURN
  AVERAGEX(__Table,[__Health %])
damit23183's avatar
damit23183
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Awesome that worked like charm.

 

Thank you so much.

 

Thanks