DistinctCount with DateFilter and Conditional Filter, with Card Visual en Table Visual.

Hello all,

Actually i have already placed this question before. I thought i had the solution for that moment.

But unfortunately!

I am looking for a distinctcount of my tripactions (Loading, Unloading,Empties) on a filtered date.

-I have 2 Tables. "Date Table" and a "DataInput Table".

-Date from the "Date Table" has a relationship with the LoadingDate, UnloadingDate and "EmptiesDate".

-Date filter, with the Value Date of the Date Table.

-I need a Card which shows me a Count of the Action on the filtered Date.

-I Need a Table Visual, which shows me exactly the same overview as in below mentioned in the example.

Card Visual

1. DistinctCount of my tripnumbers.

2. Counts of Loading if "Yes".

3. Counts of Unloading if "Yes".

4. Counts of Empties if "Yes".

I am expecting:

Loading = 3

Unloading = 2

Empties = 1

Counts on card : 6

Table Visual

Which shows me exactly as below.

So also if the unloading is on another date, but the loading on the filtered date.

I thought we had a solution with this formula per Action (Loading/Unloading/Empties)

But when i have a trip with a loading and unloading on the same day, i miss the unloadings. 

Do you have any suggestion?

Gr Alfons