Count is mismatching in detail page

[Anonymous]

Hi Team ,

Count is mismatching  between Chart1 and chart 2 and count is a measure.

Power BI File Link:  https://1drv.ms/u/s!Au-aOkl1BoHumzjPFd4NjEPZHXv2?e=k3esxR

Chart 1:  Total Showing 55

Chart 2: Here it is showing 62 but i need to show count as 55

Please let me know anything.

Thanks,

Devansh.

[lbendlin · Accepted solution]

your condition [a]>86400  hits differently depending on how you summarize by long_id, once across all hours, and once by hour.

[Anonymous]

Hi @lbendlin ,

I am new to power bi. Yes it is behaving differently. I need to show 55 for hourly also . Can you help me on the same?

Thanks,

Devansh.

[lbendlin]

Why do you need to show 55 for hourly?  That would be incorrect unless you have different rules