Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
4 years ago
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...
Need Help
Show and Tell
  • tamerj1's avatar
    tamerj1
    4 years ago

    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 )

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

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's avatar
AlanP514
Post Patron
4 years ago

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

 

Please give a solution to rectify