Count of ID with filters based on a different column - Values incorrect
Hi guys, Greg_Deckler or anyone who can help... 😕 first of all, thanks for having me... my issue is the following: I want to distinctcount the no of Trip Id's and filter by the inspection group. The problem is that this does not add up. I know what the issue is. Some trips can be admin and physical, which are both under the same column header. (Same trip Id twice) In those cases only the physical trip but not the admin trip should be counted. I tried filtering on multiple criteria, but it does not work, probably because it is all under the same column header. Any ideas how to fix this? Much obliged. Sandra I can create a measure which counts if either of those criteria is applicable: but when I try to create a measure that counts only the cases where both conditions apply, it does not work: The measure is correct, but the card value shows blank even though there are cases that both criteria apply.
