View My Drafts
Hi William, thank you for your post, it is really helpful. I have a similar situation and got stacked, if you'll have few minutes to have a look, I'll be very thankful. Basically, I have a model with some products, shops and targets in a matrix, for most of the cases the DAX measure works, but in some of them, it gives me headaches. The problem I have is with the total (SUM TO FIX) when there are 2 different targets within same shop (Shop 2), in this case, expected result should be: 2693,12.
Do you have any ideas how this could be fixed?
Please find attached the .pbix file and the expected result.
Thank you very much in advance.