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. Type is true/false, and for all records, this field is true. So my expectation is that, when I run the same metric with calculate function and put a filter of IS_PARENT equals true, it should return 4. However it returns zero. when I put false, it still returns 0.

 

It feels like I am splitting something into two halves, and I get zero for both of the halves. In my column there are no blanks, and it is a true/false field, so I do not understand how 4 = 0 + 0 

 

check_measure1 = CALCULATE([Cumulative_Users])
check_measure2 = CALCULATE([Cumulative_Users], Accounts[IS_PARENT] =true )
check_measure3 = CALCULATE([Cumulative_Users], Accounts[IS_PARENT] =false)
 
 

 

 How can this be possible? Additionally if I change all IS_PARENT values to false, then I get the value 4 for false. 
 

 

 

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • 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