Forum Discussion
Solved
Count based on disticnt value in another column
Hi Wondering if anyone could help, I'm trying to do a total cost count for accommodation, but only want to count the value once based on the Family ID (distinct count) If anyone could help I ...
Kate_McCulloch , Try using a measure for this
DAX
TotalCostByFamilyID =
SUMX(
SUMMARIZE(
YourTableName,
YourTableName[Family_ID],
"DistinctCost",
MAX(YourTableName[Total Cost Accommodation])
),
[DistinctCost]
)
worked exactly how I needed it too thank you