Forum Discussion
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 colu...
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