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!!!😊
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!!!😊