Forum Discussion

ClackamasAshley's avatar
ClackamasAshley
Frequent Visitor
3 years ago

Create a Measure for a Double-Distinct Count with a Filter on the Second Field

I'm trying to create a measure to distinctly count the number of victims (M43[Person Name]) that occur in all the cases (M43[Case Number]) in my dataset. We have suspects in the data too, so (M43[Vic...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

ClackamasAshley Try something like this:

Measure = 
  COUNTROWS(
    DISTINCT(
      SELECTCOLUMNS(
        'M43',
        "__Person", [Person Name],
        "__Case", [Case Number]
      )
    )
  )