MAXX with dimensions from 2 differents tables

[claxxx]

Hello, 

I would like to calculate my maximum sales value in the table below in the column "Max Sales" but my 2 dimensions are coming from 2 differents tables (2 differents sources) .

For the moment my Dax Formula does not include the dimension "Perimeter" so it doesn't work: 

Max Sales = CALCULATE(MAXX(VALUES(CALENDRIER[ANNEE]),CALCULATE([Sales]),ALLSELECTED())

Here in the exemple i would like to display 951 140 in all rows of my column "Max Sales"

Do you know how I can do that? 

Thank you for your help, 

[v-jayw-msft]

Hi @claxxx ,

Try:

Max Sales = CALCULATE(MAXX(calculate(VALUES(CALENDRIER[ANNEE]),filter(CALENDRIER,[Perimeter]=selectedvalue([Perimeter]))),CALCULATE([Sales]),ALLSELECTED())

Best Regards,

Jay

[parry2k]

@claxxx you want maximum sales with a year then use the following DAX measure:

Max Sales = MAXX ( ALLSELECTED ( 'Table'[Perimeter] ), [Sales] )

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[lbendlin]

Instead of VALUES(CALENDRIER[ANNEE])  use a virtual table that crossjoins the two required dimension fields.

[vpatel55]

This really helped me! 🙂