maximum revenue

[DeEviloN]

help me please. I have a list of organizations from the beginning of the year and their revenue, I need to show the maximum monthly revenue from the selected organization. Let's say I calculated the revenue for the current month, but I want to compare it with the maximum revenue of this organization. For example, in the current month, the revenue is 15, and the maximum revenue they had in February was 30, how to display it?

[v-rzhou-msft · Accepted solution]

Hi @DeEviloN ,

Here I create a easy sample to have a test.

Revenue by Month = 
CALCULATE(SUM('Table'[Revenue]),ALLEXCEPT('Table','Table'[Year],'Table'[Month]))

Current Month Revenue = 
CALCULATE([Revenue by Month],FILTER(ALL('Table'),'Table'[Year] = YEAR(TODAY())&&'Table'[Month] = MONTH(TODAY())))

Max Month Revenue = 
MAXX(FILTER(ALL('Table'),'Table'[Year] = YEAR(TODAY())),[Revenue by Month])

Result is as below.

Best Regards,
Rico Zhou

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

[DeEviloN]

[DeEviloN]

Shows this month's revenue, not the maximum

[amitchandak]

@DeEviloN ,

calculate( Maxx(values('Date'[Month Year]) , [Revenue measure]), filter(allselected(Table[Organzation]) , Table[Organzation] = max(Table[Organzation]) ) )

or

calculate( Maxx(values('Date'[Month Year]) , [Revenue measure]), filter(all(Table[Organzation]) , Table[Organzation] = max(Table[Organzation]) ) )

or

calculate( Maxx(values('Date'[Month Year]) , [Revenue measure]), filter(allselected(Table) , Table[Organzation] = max(Table[Organzation]) ) )