Total Distinctive Count

[Syndicate_Admin]

Hello I hope you can help me, I need to obtain the percentage difference of the total of a distinctive count against the distinctive count per client or failing to obtain the total in a field of the distitive count to then make some variables with that data: in the example we see that the total of the distinctive count in 370, I need that data to do several things with it.

[Greg_Deckler]

@Syndicate_Admin Try:

Measure = 
  VAR __Table = SUMMARIZE('Table',[Cliente],"__Value",[CiRUGiA AMBULATORIA])
  VAR __Result = SUMX(__Table,[__Value])
RETURN
  __Result