Max Revenue by Month Issue

[LizK75]

I have two tables:

1. IN for Invoice (contains amount and date columns) - date column is in format of Year Month 
2. Date (contains Year, Year Month, Month, and date columns)

I’ve created a relationship between IN and Date on the Year Month column (many-to-many relationship). I’ve also defined a measure (Total Revenue):

TotRev = SUM('IN'[amount])

I’m trying to create a table visualization with the following columns:

• Month (from the Date table)
• MaxRevenue: This should display the maximum revenue globally.

MaxRevenue = MAXX(ALLSELECTED('Date'[month]), [TotRev])

What I have

Janv	23300
Feb	20500
Mar	24900
Apr	18900
May	11235
Jun	9000
Jul	6500
Aug	22750
Sep	33000
Oct	33000
Nov	26750
Dec	22125

What I want 

Janv	33000
Feb	33000
Mar	33000
Apr	33000
May	33000
Jun	33000
Jul	33000
Aug	33000
Sep	33000
Oct	33000
Nov	33000
Dec	33000

[LizK75]

Thanks it works.
I forgot to add 'Date'[Month name] which is crucial.

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Amount measure: = 
SUM('IN'[amount])

expected result measure: = 
MAXX (
    ALL (
        'Date'[Year],
        'Date'[Year-Month sort],
        'Date'[Year-Month],
        'Date'[Month name],
        'Date'[Month number]
    ),
    [Amount measure:]
)