Forum Discussion

rwalsh200493's avatar
rwalsh200493
New Member
2 years ago
Solved

DAX distinct counts

Hi,   I am newish to Power Bi i am trying to find out how many operators have entered data each day.   i have removed alot of the noisey information but from the below i would like the column "Op...
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    rwalsh200493 Try:

    Table = 
  SUMMARIZE(
    'Table',
    'Table'[Date.1].[Date],
    "Operator",
    COUNTROWS(DISTINCT('Table'[Operator]))
  )
Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Open your Power Query editor and select your date column > Group by

make sure you're grouping on your date then select "Count Distinct Rows" under operation