Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If Condition

Hello All,   Iwas using IF condition to calculate based on condition.   While applying formula i could not able to select the comlumn name to filter the data. fpr example I've a table with column...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous if you want to add as measure, you need use aggregation for your type in calculation, something like this

 

If(MAX(Table[Type])="Bundle",(distinctcountmeasure), (sumof Bundle measure))
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi ,

     

    MAX function dint work, shows error as many aurguments passed for MAx function.

     

    REgards.