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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Does this measure work?

=IF(HASONEVALUE(Table[Type]),If(VALUES(Table[Type])="Bundle",(distinctcountmeasure), (sumof Bundle measure)),BLANK())

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello Ashish,

     

    I dint get any value.

     

    REgards

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

      Share the link from where i can download your PBI file.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello Ashish,

         

        I could able to share sample data which is similar to my data. 

         

        I've data from fy14 till date and month is recorded as first day of the month pattern.

        've client with size, if you abservve the client 3 whihc is a bundled type implies has say 500 clients (from columnH), my req is if i need the count for each month Client1,client2, client4 should display as 1 but for client3 it should count as 500 for month of April and 505 in May any dynamically change monthly.

         

        Please let me know if you need further details.

         

        https://drive.google.com/file/d/1BAfwWWw-_caH8VQXl_l3h1nckvfQ_WjI/view?usp=sharing 

         

        REgards