Implementing QlikSense logic into a Power BI DAX formula

Hi ManchevB 

This is usually due to that the filter context has changed when filtering. As the measure consists of three parts: [Total Time in Hours equal or less than 14], [Distinct Count of Onsite_Date_WO] and MAXX('Hours3', 'Hours3'[Standard Hours Per Country]), you can add these parts to card visuals individually to check which part doesn't return the correct result. Then you can try to correct each part one by one to get the final result. Separating and testing each part can make it easier to verify the DAX expression.

If possible, can you provide some dummy data in table format and share the desired correct outcome? We can then use the dummy data to create a demo and test any possible DAX formula. 

Best Regards,
Jing