This content has been marked as final. Show 7 replies
Sum(distinct Ordinato) returns the values I expect but is not logically correct.
Actually, it is logically correct in this case. It calculates exactly what you're asking for. The sum of the distinct values of Ordinato over all the pivot dimensions you wish to consider in calculating the sum. You already found your solution.