cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Anonymous
Not applicable

## 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?

3 REPLIES 3
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors