Forum Discussion
Solved
Need help on DAX calculation using distinct value from one column
Right now, I have data structured in a way where a value is repeated several times for each name. However, for a calculation, I only need it the one time. My current calculation works when PowerB...
This definitely helped point me in the right direction.
I ended up switching the formula to the following and it looks like it's working
SUMX(DISTINCT('Table'[Name]), CALCULATE(MAX('Table'[EBIT])))Thank you so much!!!😊
Hey there!
using AVERAGE which might not be the correct way to handle EBIT because it can be affected by row duplication. This leads to incorrect consolidated totals.
try using this:
EBIT % =
DIVIDE(
SUM('Table'[Value]),
SUMX(DISTINCT('Table'[Year]), CALCULATE(SUM('Table'[EBIT])))
) * SUM('Table'[Multiplier])
Hope this helps!
😁😁