Forum Discussion

Anonymous's avatar
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 to filter on using a slicer in the report. 

 

UniqueIClientIDTargetMonthChannelOrder Date
91/1/2018Direct Mail10-Jan-18
51/1/2018Direct Mail 
41/1/2018Direct Mail2-Feb-18
81/1/2018Email3-Mar-18
32/1/2018Direct Mail 
22/1/2018Email4-Feb-18
12/1/2018Email10-Mar-18
102/1/2018Email 
73/1/2018Email10-Mar-18
63/1/2018Email3-Mar-18

 

I want to have a date slicer in my report which is based on the order date. The user can 

 

I want to get a table/matrix visual to show the following

 

Channel name - # clients - # Orders - #ConversionRate

 

#clients = no of unique clientID in the target month or perriod selected in the date slicer. (as mentioned the slicer is based on the order date) 

#orders = no. of unique clientID where orderdate is not null and falls in the period selected in the date slicer 

 

I am stumped. Would anyone be able to please help?

 

Thanks

Anupam

 

Need Help
  • parry2k's avatar
    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.

1 Reply

  • parry2k's avatar
    parry2k
    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.