I want to do a table calculation on the following table to calculate the UNIQUE sum of the column 'Amount'. The uniqueness is defined by the Hospital Name, Date and Amount. In the example below, I want to calculate the sum(Amount) filtered as the highlighted green. If the row is not uniquely defined by Hospital Name, Date and Amount, will be treated as duplicated value, and will not be added to the calculation. Could anyone help me with that? Thanks!
In this case, the result should be: 4520+3025+5710+3465+...+3635
I don't have time to do data entry based on a screenshot and I can't open Mark twbx so I duplicated a few rows of superstore data to demonstrate a slightly different method with LOD.
1. Convert sales to a dimension, duplicate sales and convert the duplicate back to a measure.
2. Create an LOD DiDooped Sales: { FIXED [Customer ID], [Order Date], [Sales] : MIN([Sales (copy)]) }
This should eliminate the duplicate rows from the calculation.
