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/2020     10

1/2/2020     18

 

I have to calculate the range for what is in the matrix not the dataset.  From what I am gathering I cannot successfully tell PowerBI to find the MAX or MIN of a measure.  I need something to find the MAX and MIN within the matrix not the dataset.  If I use the below formula it will return a value of 5 not 10.  Can anyone help with this?

 

This formula will give me the first number pulling the Highest value in the actual dataset.  Is there anyway to tweak this to get the 10 that I need?

 

Measure = calculate(MAX(NUMBER),ALL(TABLE))
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.

     

2 Replies

  • 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!!!