Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
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
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
Can you share sample data and sample output. On excel, if needed
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |