Forum Discussion
Solved
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 c...
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 )
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 )
