Filters are not bringing records

[kasife]

Guys, can someone help me understand what might be happening?

I have the following situation: As you can see, I have a column called "Data a Contabilizar" and it has dates for the month of April.

Here I made a filter from 04/01/2023 to 04/30/2023 and it brought me the records

but when I try to filter from 4/1/2023 to 4/29/2023 the records are not brought

And in my measure it is not counting either

Does anyone have any idea what it could be?

[Ashish_Mathur · Accepted solution]

Hi,

Create a Calendar Table with a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table.  Create a slicer from the Calendar Table.  Drag the relevant fields from the Data Table.  Drag this measure to the Table

Measure = countrows(Data)

Hope this helps.

[kasife]

@Ashish_Mathur thanks

[Ashish_Mathur]

You are welcome.

[amitchandak]

@kasife ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.