Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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 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.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Syndicate_Admin Try:

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