Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Optimizing Dax formula

Workday Number = VAR CurrentMonth = SELECTEDVALUE ( 'Date'[Year Month] ) VAR MonthTable = FILTER ( ALL ( 'Date' ), 'Date'[Working Days] = "Weekday" && 'Date'[Year Month] = CurrentMonth ) RET...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    Anonymous 

     

    I would venture it is because your RANKX function doesn't have the column reference to rank the values by. Include a column reference after the table reference:

    RANKX ( MonthTable, MonthTable[...], CALCULATE ( AVERAGE ( Date[DayOfMonth] ) ),, ASC )

     

    See if that works.

     

    EDIT: you might also need an ALL or ALLSELECTED before the table expression, depending on the context you wish to calculate de Rank by:

    RANKX ( ALLSELECTED(MonthTable), MonthTable[...], CALCULATE ( AVERAGE ( Date[DayOfMonth] ) ),, ASC )

vanessafvg's avatar
vanessafvg
Community Champion
6 years ago

what error message are you getting?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    It says the syntax is incorrect but everything looks fine

     
     



    • vanessafvg's avatar
      vanessafvg
      Community Champion
      6 years ago

      www.daxformatter.com isn't throwing any errors.

       

      are you creating a calculated measure or calculated column?  also have you run this successfully before?  

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I'm creating a calculated column, yaa it was running before but now it's not

        This is the error i get