Forum Discussion
Dax Error
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
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 )
7 Replies
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.
Hi,
Do not create Year Month number and Year Month name columns. Create 3 seperate columns - Year, Month name and Month number.
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] ?
Hai Jihwan_Kim Above image from the calendar table and below image from the initiative table
Please give a solution to rectify
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 )
