If Condition

Hi All,

I'm adding a measure, please help me with a solution for this.

Need to add a measure becoz calculated column will not work for my data since i've other complications, hence should use Measure.

1. need to count unique clients for each month, i used DIstinctCount(client).

2. For Type = Bundle, it should take the count from the Count Column, for example, for Client A the clint count for May month is 50 and April 65.

3. For all Regular Client count should Client Column by using DistinctFunction.

i've created Distint count ( Disctinct Cout of column Client) as a single measure and Sum of Bundle clients (Sum(count)) as anotheer Measure, and trying to create a new measure by applying IF condition, as below 

If(Table[Type]="Bundle",(distinctcountmeasure), (sumof Bundle measure))

Please correct me and advise the solution accrordingly.

REgards