Forum Discussion

Jo_Chrq's avatar
Jo_Chrq
Helper I
3 years ago

Add Average on Bar Chart

Hi All, Using a Store table and a Sales table, I have a bar chart with income and margin per store on a bar chart. I wonder if it's possible to add average values, as if it was a store as well? So...
Need Help
Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

Hi Jo_Chrq 

 

Can you please try as a genertal measure this something like:

Average over column=
CACULATE
   AVERAGEX(
      VALUES(Table[Column]),
      [your base measure]
   ),
   ALL(Table[Column])
)

 

for table[column] use your strore column.

 

To make sure that you have the average as a separate bar in the end you would need to add the "average" value in the dimension table with a dummy key or something. Then it might be possible with the following appraoch:

 

with seperate abr chart =
IF(SELECTEDVALUE(Table[Column])="Average"),
   CACULATE
      AVERAGEX(
         VALUES(Table[Column]),
         [your base measure]
      ),
      ALL(Table[Column])
   )
   ,[your base measure]
)

 

without knowing the complete data model it is hard to give a answer on point but I hope it helps you.

 

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.