topic Re: parentheses issue in DAX Commands and Tips

parentheses issue

Memphis28 — Thu, 29 Feb 2024 14:44:35 GMT

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?

Re: parentheses issue

Greg_Deckler — Thu, 29 Feb 2024 14:52:00 GMT

Memphis28 Should be something like:

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

Re: parentheses issue

Memphis28 — Fri, 01 Mar 2024 08:02:37 GMT

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?