Forum Discussion
Solved
Need help adding unique values across multiple columns
Hi All I have a table like below that has 5 columns and each row has a unique combination (Fund, Item, Line, Year). I need a dax formula that will look at an entire table and sum the amounts for ...
Hi Userpath77 ,
Below is my table:
The following DAX might work for you:
Measure = CALCULATE( SUM('Table'[Amount]), ALLEXCEPT('Table','Table'[Line]) )The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Dangar, I need the actual measure
