Forum Discussion
Calculate Distinct Key with Multiple Duplicate Line Items
I am trying to calcuate for distinct values where a customer order returns multiple delivery orders, while excluding the packaging IDs. TABLE 1 Customer Order # Delivery Order Packaging ID ...
Hi Justin_Spiegel ,
Why are you using a calculated column the type of calculation you describe would be calculated more efectively on a measure. Making a calculated column you will have the table context that will need additional context.
So depending on where you use the measure you can have the result you need in this case simply use the measure:
Count order =DISTINCTCOUNT('Table 1'[Key])