Hi so that UV issue you face is a typical challenge as the metric has that de duplication done y Adobe in its back end.
Ideally instead of trying to do that ton of post processing yours self. I recommend you do multiple queries your self in PBI.
So lets you want daily totals, do a query for daily,...