Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Total Distinctive Count

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 ...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Syndicate_Admin Try:

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