Forum Discussion
Solved
Distinct Count - How to get correct row level figures?
Hello, I'm struggling a lot with this : Calculating a distinct count at the row level doesn't seem to work. Only the total is distinct.I have a table that aggregates a list of accounts by dimensi...
qmartiny , Try a measure like
Sumx(Summarize(Table, Table[Region Lvl 1],[Region Lvl 2], "_1",DistinctCount(Table[PE_ID])),[_1])
qmartiny , Try a measure like
Sumx(Summarize(Table, Table[Region Lvl 1],[Region Lvl 2], "_1",DistinctCount(Table[PE_ID])),[_1])