Forum Discussion

jetform_consult's avatar
jetform_consult
Helper I
2 years ago
Solved

Measure taking on invalid values

I have a Measure called [SelectedDate]. ``` SelectedDate = IF(SELECTEDVALUE(OrdersByCalendar_DTL[OrderDate] )=Blank();Blank();SELECTEDVALUE ( OrdersByCalendar_DTL[OrderDate])) ``` I am attempting...
  • jpessoa8's avatar
    jpessoa8
    2 years ago

    Sorry for the misunderstanding jetform_consult.

     

    At the moment what is the behaviour on the Month graph? Can you provide a print? I couldn't understand from your explanation


    Best regards,
    Jorge Pessoa

jetform_consult's avatar
jetform_consult
Helper I
2 years ago

Hi Jorge...Thanks for your valuable time.

 

I believe I found the issue.  The problem only reared its ulgy head when I attempted to clean up (what I thought were) unneeded tables from 5 downto 3.  It was then the relations between the new consolidated tables and the rest of the tables that 'somehow' caused the measures to misbehave.

 

I simply went back to the original table format, cleaned up a few unneeded relationships with the new tables, and everything started working again.

 

Thanks once again for your tips and your time.