Dax Error

[AlanP514]

Hai All I need help on this 
Requirement: Want to create a pie chart 
1 by default it should show max month otherwise it should show selected month v/s category column(column consist of different categorical values.
So I created a measure for this but that is showing an error.

This is the Measure I created but while applying 

I am getting this kind of error, please help me to rectify this 

[tamerj1 · Accepted solution]

@AlanP514 

Please try

CM =
VAR MaxMonth =
    CALCULATE ( MAX ( Initiative[Year Month] ), REMOVEFILTERS ( 'Calendar' ) )
VAR SelectedMonth =
    SELECTEDVALUE ( 'Calendar'[Year Month] )
VAR FinalMonth =
    IF ( [Is Year Filtered] = TRUE (), MaxMonth, SelectedMonth )
RETURN
    CALCULATE ( [# Model Number], 'Calendar'[Year Month] = FinalMonth )

[AlanP514]

Hai @tamerj1 
Thanks this is working

[Jihwan_Kim]

Hi,

May I ask and please check how is the column 'Initiative'[Year Month] look like? Is it looking like the same as 'Calendar[Year Month Name] ?

[AlanP514]

Hai @Jihwan_Kim  Above  image from the calendar table and  below image from the initiative table

Please give a solution to rectify

[Ashish_Mathur]

Hi,

The Data type of _finalyear is alphanumeric (I assume) whereas the data type of Year_month is numeric.  that is reason fo the error.

[AlanP514]

Hai @Ashish_Mathur 

and for calendar i created fully as Dax

How to rectify this issue
 

[Ashish_Mathur]

Hi,

Do not create Year Month number and Year Month name columns.  Create 3 seperate columns - Year, Month name and Month number.