Forum Discussion
Solved
DISTINCT COUNT - From Another Table as String
Hi All, I have been at this for hours and looking thorugh other post's nothing quite works. Hours_Spend_Data - is my data table which contains all weeks worked, hours, charges by site / colleagu...
How about this?
CALCULATE ( DISTINCTCOUNT ( Hours_Spend_Data[Weeks_Worked] ) )
I'm 99.9% sure I tried calculate count and calculate distinct count.
will triple check in the morning.
- AlexisOlson
Super User
Maybe you tried it without CALCULATE. That function needs to be included so that it does a context transition and filters Hours_Spend_Data by the current row rather than calculating the distinct count over the entire table.