cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Tob_P
Helper IV
Helper IV

MAX Measure calculating total & additional rows in Matrix

I have created a MAX Measure..

 

MAX Measure = MAXX(ALLSELECTED('Sales Header'[Sell-to Customer Name]),[Sales Line Amount])
 
Which is working fine as it is catching the max value of all the quotes (third level in hierarchy) relating to the first level in my hierarchy.
However the measure is also calculating the max value of each of the quotes in the matrix. How can I amend my DAX to get it to not do so..
 
TobP1.png
 
Additionally, it is also summing the MAX value in the column total...
 
TObP2.png
...across all the lines and would prefer that to not happen.
 
Have tried calculated column instead but with no success. Fields included in the matrix hierarchy are all from the same table.
Any ideas please?
1 REPLY 1
tamerj1
Super User
Super User

Hi @Tob_P 

please try

MAX Measure =
IF (
    NOT ISEMPTY ( VALUES ( 'Sales Header'[Sell-to Customer Name] ) ),
    MAXX (
        ALLSELECTED ( 'Sales Header'[Sell-to Customer Name] ),
        [Sales Line Amount]
    )
)

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors