cancel
Showing results for
Did you mean:
New Member

## MAXX with dimensions from 2 differents tables

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?

3 REPLIES 3
Community Support

Hi @claxxx ,

Try:

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

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User

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

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

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.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User

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

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.