Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Client and Order Counts?

Hi In my dataset we have a client ID, the channel we used to target them, the month we targeted them and the date we recieved the order. There are a bunch of other columns that we want to be able...

parry2k
7 years ago
Anonymous try following measures:

# Clients = COUNT( Table[UniqueClientId] )

# Orders = CALCULATE( [# Clients], Table[Order Date] <> BLANK() )

Use table visual, add "Channel", "# Clients", "# Orders" on value and check the result.

Super User

7 years ago

Anonymous try following measures:

# Clients = COUNT( Table[UniqueClientId] )

# Orders = 
CALCULATE( [# Clients], Table[Order Date] <> BLANK() )

Use table visual, add "Channel", "# Clients", "# Orders" on value and check the result.