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 colu...
Need Help
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