Count % of tickets with only one appointment.

[tobiasnygren]

Hi!
I need help with how to write the dax code for how to
 - count number of tickets that only have one appointment in the detail table
 - count number of ticket that have more than one appointment in the detail table
 - count number of tickets that do not exist in the detail table

I don't get it to work correct.

See example in the picture.

[Greg_Deckler · Accepted solution]

So, should be something like:

Number with only 1 =
  VAR __Table = 
    GROUPBY(
      'Table',
      [Ticket No],
      "Count",COUNTX(CURRENTGROUP(),[Schedule date])
    )
RETURN
  COUNTROWS(FILTER(__Table,[Count] = 1))

Should all be a variation of that.

[tobiasnygren]

Works perfect!
I really appreciate your quick help.

Thank you very much!

[Greg_Deckler]

Anytime @tobiasnygren !