Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Display value based on highest selected value within multiple selections

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.

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!

2 Replies

  • stevedep's avatar
    stevedep
    Memorable Member
    5 years ago

    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))
  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    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!