Max value of the week in the day

[Anonymous]

Hi 

Someone can help me with this situation?

I need show the max value of the week every day, is It possible?  What measure I need use?

I put a picture bellow that I need do.

Sorry for the bad English

[amitchandak]

@Anonymous ,

Calculate(Maxx(values('Date'[Week Day]), [CONTAGEM]), filter(allselected('Date'), 'Date'[Week] = Max('Date'[Week]) ))

[v-zhangti · Accepted solution]

Hi, @Anonymous 

Please try the following methods.

Measure:

Measure =
CALCULATE (
    MAX ( 'Table'[Value] ),
    FILTER (
        ALL ( 'Table' ),
        [Week number] = SELECTEDVALUE ( 'Table'[Week number] )
    )
)

Does this meet your desired outcome?

Best Regards,

Community Support Team _Charlotte

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