topic Count is mismatching in detail page in DAX Commands and Tips

Count is mismatching in detail page

Anonymous — Thu, 23 Nov 2023 11:51:28 GMT

Hi Team ,

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

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 — Sat, 25 Nov 2023 02:35:35 GMT

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

Anonymous — Sun, 26 Nov 2023 17:34:48 GMT

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 — Sun, 26 Nov 2023 17:53:32 GMT

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