Solved: Combining Average and Individual Values in Table

Anonymous · ‎02-28-2020

v-chuncz-msft · ‎03-01-2020

@Anonymous

You may try to use ALLSELECTED.

AVERAGEX (
    ALLSELECTED ( 'Table'[ISIN] ),

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎03-01-2020

@Anonymous

You may try to use ALLSELECTED.

AVERAGEX (
    ALLSELECTED ( 'Table'[ISIN] ),

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler · ‎02-28-2020

Is there a relationship between those two tables?

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...