DAX formula Help averages

[Anonymous]

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? 

[v-shex-msft]

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

[v-shex-msft]

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

[amitchandak]

Can you share sample data and sample output. On excel, if needed