Dax Formula for Multiple Conditions and Types with different data types

DAX DAX Calculations
21

Hello

I added a page to this file. Page 2 was more what i was expecting. Page 1 looks like it is selecting incorrect dates?

Finally how can i show a total value in a Card format

Data Model Testing.pbix (23.1 MB)