Client and Order Counts?

[Anonymous]

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. 

UniqueIClientID	TargetMonth	Channel	Order Date
9	1/1/2018	Direct Mail	10-Jan-18
5	1/1/2018	Direct Mail
4	1/1/2018	Direct Mail	2-Feb-18
8	1/1/2018	Email	3-Mar-18
3	2/1/2018	Direct Mail
2	2/1/2018	Email	4-Feb-18
1	2/1/2018	Email	10-Mar-18
10	2/1/2018	Email
7	3/1/2018	Email	10-Mar-18
6	3/1/2018	Email	3-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

[parry2k · Accepted solution]

@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.