Forum Discussion

MichaelSamiotis's avatar
MichaelSamiotis
Icon for Resolver I rankResolver I
3 years ago
Solved

Data modelling with Dim dates[Year] doesn't work

Hello all.   I have the below DAX (1) which doesn't work (returns nothing) and I don't get why. When I change it to the second DAX code (2) it works fine. I have a 1-* relationship between Dim Date...
General Comment
Need Help
Show and Tell
  • BrianConnelly's avatar
    BrianConnelly
    3 years ago

    Is the relationship Active?  Your code should work as written so something else is going on.  Could try this code to test out the variables....

    Customers =
VAR theYear = YEAR ( TODAY() )
VAR currentDateYear = MAX(Dim Dates'[Year])
VAR calculation =
CALCULATE (
DISTINCTCOUNT ( 'Fact Sales'[customer_id] ),
'Dim Dates'[Year] = theYear 
)
// RETURN calculation  // Uncomment to see the executed value
// RETURN theYear // Uncomment to see the executed value
// RETURN currentDateYear // Uncomment to see the executed value
KeyurPatel14's avatar
KeyurPatel14
Icon for Responsive Resident rankResponsive Resident
3 years ago

Hi MichaelSamiotis ,
Can you please provide your pbix file? 
Because I think it should work as you expected.

  • MichaelSamiotis's avatar
    MichaelSamiotis
    Icon for Resolver I rankResolver I
    3 years ago

    Sorry can't due to data protection issues but I really don't get why it doesn't work. It should. Data formats are both integers (whole numbers), I have a 1 to * relationship on the date filed.

    • BrianConnelly's avatar
      BrianConnelly
      Icon for Resolver III rankResolver III
      3 years ago

      Is the relationship Active?  Your code should work as written so something else is going on.  Could try this code to test out the variables....

      Customers =
VAR theYear = YEAR ( TODAY() )
VAR currentDateYear = MAX(Dim Dates'[Year])
VAR calculation =
CALCULATE (
DISTINCTCOUNT ( 'Fact Sales'[customer_id] ),
'Dim Dates'[Year] = theYear 
)
// RETURN calculation  // Uncomment to see the executed value
// RETURN theYear // Uncomment to see the executed value
// RETURN currentDateYear // Uncomment to see the executed value