Forum Discussion
jesusssss
Helper II
Helper IIHow to make a count function to search for data without taking the date into account.
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.
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
4 Replies
- amitchandak
Super User
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.
jesusssssThank 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
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
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
