Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Anonymous , Try two measures like

 

M1= CALCULATE(DISTINCTCOUNT('Fact table'[Carton ID]),USERELATIONSHIP('Rolling Calendar'[Date],'Fact table'[Delivered date]))


Sumx(SUMMARIZE( 'Fact table'[Destination store],
[Week Number], "Delivered qty", [M1], "Max Rece Capa", MAX('Dimension table'[Rec. Cap.])), IF([Delivered qty]>[Max Rece Capa],1,0))