Forum Discussion
DAX measure not returning expected result
Hi Fabric Community, Can you help me with DAX below? The DAX for a measure but didn't return the expected result. Goal result: How many overdeliveries happened across the stores in a week? I ...
Hi amitchandak ,
Thanks for the solution!
I tried it but it seems not working. The M1 is returning total sum of carton but not cartons delivered to store.
Is there any thing wrong with my DAX solution? I am thinking if it could be the modelling: the matrix is using the "Rolling_calendar"[Week Number] and "Dimension table"[Destination Store]. The Dimension table has a 1-to-many relationship with the fact table . Thanks!
Cheers,
Tian