Measures that bring inn old categories, outside of date ranges

[hr_tetra]

Hi All,

Normally when doing measures, and you e.g. add a table with categories and the measure, within a date range, you would normally only get values for the categories that actually have values for the period. So e.g. the last month we have data from batch 20-25.

But for some measures, I will get all the previous batches included,  even those closed out and with no generated data. So batch 1-25 will be included, and all the old and inactive/finished batches will have a value of zero.

Can anyone explain why measures sometimes lead to this behaviour? It is a bit of a hassle trying to filtering out the old values without affecting real values.

Best regards,

Ole

[johnt75 · Accepted solution]

It depends on whether the measure returns blank or 0. If the measure returns blank then by default those values will be filtered out, but if it returns 0 then the values will be shown.

[hr_tetra]

Aha, turns out the measure I was working on excluded some groups (those 0 or blank), so I added an IF(AND() for zero and blank, and now it works normally. Thanks!