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 )

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

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

    Hai Ashish_Mathur 

    and for calendar i created fully as Dax

     

    How to rectify this issue
     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Hi,

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