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]))
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

rwalsh200493 Try:

Table = 
  SUMMARIZE(
    'Table',
    'Table'[Date.1].[Date],
    "Operator",
    COUNTROWS(DISTINCT('Table'[Operator]))
  )
rwalsh200493's avatar
rwalsh200493
New Member
2 years ago

This solution was ideal thanks as i needed to complete this through DAX and not the power Query editor as i used DAX to create the table. I should have put that in the intial brief