Hi
Hoping someone can help as I’m not sure what the best way is of going about this…
I have a table that looks like below where I’m trying to have Volumes in Table B multiplied with a rebate amount contained in Table C using SUMX( Table A, 'Table B [Volume Value] * 'Table C [Rebate Value])
The rebate table C is a table showing rebates by Zone which I cant join with Table A (without creating a Many to many relationship)
Initial thoughts are to using something like the below to get a unique rebate value or using SUMMARIZE to allow for valid combinations in SUMX although in both instances SUMX doesn’t calculate correctly although I could be missing something simple
= CALCULATE( min(‘Table C’[Rebate Value]) ,FILTER(‘Table C’,‘Table C’[Site] = FIRSTNONBLANK(‘Table A’[Zone],‘Table A’[Zone])))
Thanks in advance