Errors in filtering

[KatkaS]

Dears,

I know the error could be anywhere, but I'm trying my luck, as I spend hours on solving this:

When I filter ALL periods, then I get result on Overdue invoices.

BUT when I filter only ONE period (no matter which one), I get nothing (zeros... - which is nonsense, my file has data..).

Could anyone please try to think what it could be?

Thank you very much!

[v-eachen-msft]

Hi @KatkaS ,

You could check if your date formats are different. This will cause them to return blank results after comparison. 

Could you please share your sample data and excepted result to me if you don't have any confidential Information. Please upload your files to One Drive and share the link here.

[KatkaS]

Thank you for your time!

I tried to add the file in OneDrive, it should be here:

https://epiroc-my.sharepoint.com/:u:/p/katerina_simerdova/EbBq3EZ0H51MhR1xPRsQWG0BbkvBct7CBRQ7l6ksQz...

Thank you!

[Anonymous · Accepted solution]

The file is not available for public sharing probably because your system administrator disabled this feature for your tenant. Is there another way you can share the file?

[KatkaS]

Thank you, Jeroen, it's no longer necessary, it was due to a different time format in second sheet....

But thank you very much for your time!

[KatkaS]

Hello Jeroen, I could email it to you, if ok with you.. Otherwise I have no idea.. do you have any suggestion..?

[Anonymous]

What measure do you use to calculate the overdue invoices and what does your data model look like at the moment. Seems to me as if something in the relations is not setup quite right.

[KatkaS]

Thank you for yout time, Jeroen!

Measure is very simple (the data file) contain only overdue invoices, so the calculation is

# Overdue invoices = COUNTROWS('#11 EINS Aging')+0

Is it possible that the issue is due to the fact,

that in my visual I have measures from two different excel sheets..?

Visual is below, I filter based on HUB or FAM or Period..