Forum Discussion

Memphis28's avatar
Memphis28
Frequent Visitor
2 years ago

parentheses issue

Afternoon everyone
I am hoping this is obvious but i am struggling. Any reason i would be getting an error on the final perentheses of each line for the _max and _min variables. I can't take credit for the measure, not entirely but from my working knowledge i can't see any issues. Anyone able to help?

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    Memphis28 Should be something like:

    MAXX( ALLSELECTED( 'FactCallDetail'[StartTimeCall].[Day]) , [StartTimeCall])

    • Memphis28's avatar
      Memphis28
      Frequent Visitor
      2 years ago

      Thanks for that. It has cleared the issue with the fromula however the scorecard isn't updating/accurate based on the dates selcted in the slicer. Could this be to do with how the date is formatted, I have checked and it is defined as a date column?