Display value based on highest selected value within multiple selections

[Anonymous]

Hi Team,

I want the result of test growth to display 0.71 based on the highest month which is July but it ended up sum all of the value and ended up with result -1.0 for the total value.

Is there anyway to display only row value based on highest selected month that come with multiple selections as title mentioned.

Thank you.

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

Create a measure as below:

_Growth = 
var  _maxmonth=CALCULATE(MAX('Table'[Month]),ALLSELECTED('Table'))
Return
IF(ISINSCOPE('Table'[Month]),
SUM('Table'[Growth]),
CALCULATE(SUM('Table'[Growth]),FILTER(ALL('Table'),'Table'[Month]=_maxmonth)))

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[stevedep]

Perhaps something like this, (btw its a DAX question):

Measure = 
VAR _MaxMonth = calculate(max(month), allselected(months))
return
calculate(max(test growth)), filter(data, month = _MaxMonth))