Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX formula Help averages

Hi All,

I am quite new to Power Bi and don't have any previous experience with DAX formulas so I am hoping someone can help me.

I am trying to build a Line and Clustered Column Chart where the column chart is displaying sales of pre-defined "target accounts". On the line value I am trying to display an average of sales of "all accounts' at product level rather than average sales at account level. I believe this can be done through DAX but not sure how to proceed.

I hope i have explained this clearly and someone has advice on this topic? 

 
 
Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous,

    How your chart designed? Since we not so clear for your data structures, can you please share more details information to help us clarify your scenario?

    How to Get Your Question Answered Quickly 

    In addition, you can also try to use the following measure formula if it meets for your requirements. (it summary current filter table records and group by columns series)

    AVG =
CALCULATE (
    AVERAGE ( Table[Amount] ),
    ALLSELECTED ( Table ),
    VALUES ( Table[ColumnSeries] )
)

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous,

    How may fields are you used on the shared axis fields? Please add them(except your account field) to below formula and package with values function, link with 'delimiter' to replace 'values(sheet1[Shared axis])' part:

    Measure =
CALCULATE (
    AVERAGE ( Sheet1[Sales Amount USD BR] ),
    ALLSELECTED ( Sheet1 ),
    VALUES ( Sheet1[Shareed axis] ),
    VALUES ( Sheet1[TPG] )
)

    Regards,

    Xiaoxin Sheng