Power Bi displays wrong information after applying filter of a measure

[Anonymous]

So I am using Power BI live connection. I have 2 measures:

Latest Call Bool =

CALCULATE ( MAX ( TeamsCalls[StartTime] ), ALLEXCEPT ( TeamsCalls, TeamsCalls[CallTo] ) )

Latest Call Filter = IF ( MAX ( TeamsCalls[StartTime] ) = TeamsCalls[Latest Call Bool], 1, 0 )

The last measure returns which values are the latest and those values get marked by '1'.

I then proceed to make a list and filter it by my measure 'Latest Call Filter' to only display values that equal 1, which return 3 correct values for me.

Unfortunately, if I add the measure to the list, it displays them all as 0, even if it should be 1.

Why is this happening? Any help would be appreciated

[dax]

Hi moiseman159,

I test this in my environment, which works well. So if possible, could you please inform me your sample data or report file , then I will test this in my environment and help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

StartTime,StopTime,CallFrom,CallTo,Duration (ms),CallStatus
2019-09-01 07:39:05,2019-09-01 07:39:11,+55555555555,+444444444444,5527,completed
2019-09-01 07:38:58,2019-09-01 07:39:04,+55555555555,+333333333333,6259,completed
2019-09-01 07:23:51,2019-09-01 07:23:56,+55555555555,+444444444444,5575,completed
2019-09-01 07:23:40,2019-09-01 07:23:47,+55555555555,+333333333333,7434,completed
2019-09-01 07:08:33,2019-09-01 07:08:38,+55555555555,+444444444444,5598,completed
2019-09-01 07:08:24,2019-09-01 07:08:31,+55555555555,+333333333333,6377,completed
2019-09-01 06:53:13,2019-09-01 06:53:18,+55555555555,+444444444444,5548,completed
2019-08-29 18:01:25,2019-08-29 18:01:51,+55555555555,+333333333333,25398,failed
2019-08-29 17:46:18,2019-08-29 17:46:24,+55555555555,+444444444444,5545,completed
2019-08-29 17:45:52,2019-08-29 17:46:17,+55555555555,+333333333333,25187,failed
2019-08-24 14:44:59,2019-08-24 14:45:16,+55555555555,+333333333333,16137,failed
2019-08-23 14:44:59,2019-08-23 14:45:16,+55555555555,+22222222222,16137,failed
2019-08-23 14:44:59,2019-08-23 14:45:16,+55555555555,+333333333333,16137,failed

Paste that in a Csv file. You will have to change the phone number data type to Text. 

I tested this data without the live connection and it seems to work, so I assume it has something to do with the data set(which is a Push type), or the fact that its live connection. I will try to reproduce the issue with a seprate dataset, one that I controll.