Dynamic calculation of column totals in row context

[DomantasK]

Hi all,

I'm having problem with these calculations... Basically, my goal is to get two numbers:

1: number of total distinct workers from start of selected date period

2: number of total distinct workers from end of selected date period

*And it has to be responsive to the group and date filtering.

Columns I have: 

[Group]

[Works since]

[Name]

[Distinct count column] (idk if I need it?)

As I imagine it should work like this?:

 

 

[Greg_Deckler · Accepted solution]

@DomantasK Not sure I 100% understand but should be something like:

SUMX(ALLSELECTED('Table'),[Distinct Count Column])

[DomantasK]

And it really was just that simple... Thank you, works perfect! 🙂