Forum Discussion

common763's avatar
common763
Helper III
5 years ago
Solved

MAX VALUE/MEASURE ISSUE

I currently have a dataset that has rows similar to the below. 1/1/2020     5 1/1/2020     5 1/2/2020     8 1/2/2020     10   My matrix table sums those values together as displayed below: 1/1...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi common763 ,

     

    Please create a measure like this.

    __Max_value = 
VAR __table = SUMMARIZE( Sheet4, Sheet4[Date], "__Value", SUM(Sheet4[Value]) )
RETURN 
MAXX(
    __table,
    [__Value]
)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi common763 ,

 

Please create a measure like this.

__Max_value = 
VAR __table = SUMMARIZE( Sheet4, Sheet4[Date], "__Value", SUM(Sheet4[Value]) )
RETURN 
MAXX(
    __table,
    [__Value]
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • common763's avatar
    common763
    Helper III
    5 years ago

    This works.  Accepting as a solution.  Thanks for your help!!!