Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Calculate function not working as expected

Hi all   I have a metric which keeps track of cumulative users against dates, there are 4 users at the end of my period. I have a column which tells me if a customer is a parent or not, IS_PARENT. ...
Need Help
Tips and Tricks
Tutorial Requests
TomMartens's avatar
TomMartens
Super User
2 years ago

Hey Anonymous ,

 

unfortunately some information is missing

  • DAX statement for the measure [Cumulative_Users]
  • data type of the column [IS_Parent]

Also, povide a screenshot of the datamodel that contains the tables and relationships that are affected by the measures.

 

Regards,

Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi TomMartens , thank you so much for your response. Actually I have simplified my problem

     

    I changed IS_PARENT to integer and put random values, 44 and 55.

    For both of these measures it is returning zero.

    check_measure2 = CALCULATE([Cumulative_Users], Accounts[IS_PARENT] =44)
    check_measure3 = CALCULATE([Cumulative_Users], Accounts[IS_PARENT] =55)
     
    However this measure returns 4
     
    check_measure1 = CALCULATE([Cumulative_Users], Accounts[IS_PARENT] =0)
     
    Surely I must be missing something here, because the value zero does not even exist as a value in my field