My first post on this brilliant site, so apologize in advance if I’m not following the correct protocol…
I have the following visual
Where the measure Del vs Actual Days determines the difference between Delivery Date (the promised date) and Actual PGI Date (the actual date of shipment). The DAX for Del vs Actual is below
Del vs Actual Days =
DATEDIFF( MIN(SalesOrders[Delivery Date]), MIN(Shipments[Actual PGI Date]),DAY),
FILTER( VALUES( SalesOrders[Sales Document]), ‘SalesOrders’[Sales Document] = max(Shipments[Sales Document] )
Now using this existing measure (Del vs Actual Days), how can we create another measure to count the number of occurrences <= 0 and >=1 to use in a card visual.