topic Re: Alter DAX measure to display highest value in a line chart in DAX Commands and Tips

Alter DAX measure to display highest value in a line chart

Tini-Bee — Sun, 09 Feb 2025 10:41:24 GMT

I want to return the highest Sum Range Space ( ie check and store the highest value 6408) in the Line chart below. I want the line chart to be straight and not 'dip' to 300 on dates when Sum Range Space is below 6408

I've selected two Houses;
1) House 1 with Sum Range Space = 6108
2) House 2 with Sum Range Space = 300

When both are selected they should return Sum Range Space = 6408 and not 300 as in the screenshot above

Measure I want to alter:

Sum Range Space =
VAR RangeSpaceCount = CALCULATE(COUNT(' Build_Capacity'[RangeSpace]

VAR TotalCount = CALCULATE(DISTINCTCOUNT('Build_Usage'[ID]), ALL('Date'))

VAR BLANKK = BLANK()

RETURN

IF (

(

ISFILTERED ( 'Hs'[House Name] )

&& RangeSpaceCount = TotalCount

[SumRangeSpace1],

BLANK()

)

The underlying measure [SumRangeSpace1] is

SumRangeSpace1 = CALCULATE (

SUM( 'Build_Capacity'[RangeSpace] ),

TREATAS (

VALUES ( 'Build_Usage'[ID] ),

'Build_Capacity'[ID]

)

)

Build_Capacity

Build_Usage

Relationship

Re: Alter DAX measure to display highest value in a line chart

speedramps — Sun, 09 Feb 2025 14:00:57 GMT

We want to help you but your description is too vague. Please write it again clearly.

Please DON'T copy & paste your DAX that does not work and expect us to fathom what you want to do. That is a bit crazy. 😀

Please just give a simple non technical functional description of what you want, then let us suggest the solution. Thank you.

Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.

Remove any unneeded columns which may cause confusion.

Rename columns to user friendly names. Avoid jargon like Build_Capacity'[RangeSpace].
Also provide the example desired output, with a clear step-by-step description of calculations the process flow.
Remember not to share private data ... we don't want you to get into trouble. 😧
Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
Try keep it simple and ask one question per ticket.
You will get a quick response if you put time, care and effort into writing clear problem descriptions.
Remember you are gertting free expert help, so please put lots of proper effort to asking questions and providing examples.

Vaugue descriptions can waste your time and our time.

Look forward to helping you when the above information is forthcoming

Perhaps you can learn DAX and adapt the logic from this example, which prevents the line dropping below 20% of the max.

Note how the CALCUALATE use ALL to get the max value.

Then the IF returns the actual or base value

Please click thumps up for the helpful suggestions and then [accept solution] if it works. Thanks

Answer = // Get your actual value var actualvalue = SUM(yourdata[Amount]) // Get 20% of max value var base = CALCULATE( MAX(yourdata[Amount]), ALL(yourdata[Dates]) ) * 0.20 RETURN // dont go below the base value IF(actualvalue < base, base, actualvalue)

Re: Alter DAX measure to display highest value in a line chart

Tini-Bee — Mon, 10 Feb 2025 07:47:59 GMT

Thanks for your advice;
using the fix provided I want to utilise the CALCULATE MAX as follows:

Sum Range Space =

varTest = CALCULATE(MAX([SumRangeSpace1], ALL('Date')))
VAR RangeSpaceCount = CALCULATE(COUNT(' Build_Capacity'[RangeSpace]

VAR TotalCount = CALCULATE(DISTINCTCOUNT('Build_Usage'[ID]), ALL('Date'))

VAR BLANKK = BLANK()

RETURN

IF (

(

ISFILTERED ( 'Hs'[House Name] )

&& RangeSpaceCount = TotalCount

[SumRangeSpace1],

BLANK()

)

The underlying measure [SumRangeSpace1] is

SumRangeSpace1 = CALCULATE (

SUM( 'Build_Capacity'[RangeSpace] ),

TREATAS (

VALUES ( 'Build_Usage'[ID] ),

'Build_Capacity'[ID]

)

Re: Alter DAX measure to display highest value in a line chart

Tini-Bee — Fri, 14 Feb 2025 12:02:31 GMT

rectified this issue using
CALCULATE([SumRangeSpace1], ALL('Date'))