Calculate function not working as expected

[Anonymous]

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. 

[TomMartens]

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]

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