How to make a count function to search for data without taking the date into account.

[jesusssss]

Hello good day.
I am trying to make a formula to be able to get a specific value from a conditional column that I have created.

I am using this expression "COUNTAX(FILTER('Incidencias generales calidad 7','Incidencias generales calidad 7'[Custom]="1"),[Measure 5])"
what happens is that when I filter by months I realize that only half of the data is 
taking me and the other half is left as blank 

And reviewing the data I have seen that the data that is left as blank 
is because the date column is duplicate because that operation was closed on the same day.

I would like to know if there is any work so that when searching for data using a filter, it does not take the date column
into account or does not mark the repeated date data as blanks.

Thanks.

[Anonymous]

Hi @jesusssss ,

If you want to remove the filtering of dates, try to use the REMOVEFILTERS function.

For example,

Measure = CALCULATE(SUM(Locations[Amount]),REMOVEFILTERS('Locations'[LocationName]))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jesusssss · Accepted solution]

Thank you very much for the answer, in the end I managed to solve the error and the problem is that the
 table was duplicated several times and that was causing failures in the measurements

[amitchandak]

@jesusssss , You should create this as measure not column

COUNTAX(FILTER('Incidencias generales calidad 7','Incidencias generales calidad 7'[Custom]="1"),[Measure 5])

Column will not consider slicer value

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[jesusssss]

Thank you very much for the answer, in the end I managed to solve the error and the problem is that the table
 was duplicated several times and that was causing failures in the measurements