MAX VALUE/MEASURE ISSUE

[common763]

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))

[v-lionel-msft · Accepted solution]

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]

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