topic Re: Sum maxx in DAX Commands and Tips

Sum maxx

Vanessa250919 — Mon, 13 Mar 2023 05:59:02 GMT

Hello,

I try to have a measure to have a sum for the value for one column .

I need in my graph the max value and not a variation value, it's possible ?

Thanks in adv.

Re: Sum maxx

tamerj1 — Mon, 13 Mar 2023 06:46:24 GMT

HI Vanessa250919
Please provide more information

Re: Sum maxx

Vanessa250919 — Mon, 13 Mar 2023 07:12:00 GMT

POSTAL_CODE               NBR_PAR
1000                            2
2000                              4

3000 2

In my graph in need the sum 8 and not the maxx 4 .

Re: Sum maxx

tamerj1 — Mon, 13 Mar 2023 07:41:43 GMT

Vanessa250919
Is [NBR_PAR] a column in the sorce table or a measure?

What are you slicing by in the graph? Aea, city, date, month?

Re: Sum maxx

Vanessa250919 — Mon, 13 Mar 2023 07:47:24 GMT

is an column .
city in graph .

Re: Sum maxx

tamerj1 — Mon, 13 Mar 2023 07:58:42 GMT

Vanessa250919
It should work. Double check the data type of the 'Table'[NBR_PAR] column. It has to be a number not a text.
You may also create a measure

NBR_PAR_Measure = SUM ( 'Table'[NBR_PAR] )

Re: Sum maxx

Vanessa250919 — Mon, 13 Mar 2023 08:20:28 GMT

Ok, it's work, but I need to used the max of this measure in my graph to have a steady bar

Re: Sum maxx

tamerj1 — Mon, 13 Mar 2023 08:40:42 GMT

Vanessa250919
Max Postal Code for each city? or Max City among all cities? The later would be

NBR_PAR_Max = MAXX ( ALLSELECTED ( 'Table'[City] ), CALCULATE ( SUM ( 'Table'[NBR_PAR] ) ) )

Re: Sum maxx

Vanessa250919 — Mon, 13 Mar 2023 08:47:37 GMT

Max for all cities, in this case I have max for one city

Re: Sum maxx

tamerj1 — Mon, 13 Mar 2023 08:54:34 GMT

Vanessa250919

NBR_PAR_Max =
MAXX ( VALUES ( 'Table'[Postal Code] ), CALCULATE ( SUM ( 'Table'[NBR_PAR] ) ) )

Re: Sum maxx

Vanessa250919 — Mon, 13 Mar 2023 08:58:03 GMT

I try this measure and I have the same result

Re: Sum maxx

tamerj1 — Tue, 14 Mar 2023 04:51:03 GMT

Vanessa250919
Please provide some sample data along with the expected result.