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
v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi,

 

You can create measure Count Clients to distinct count the [Clients], and create measure Filter1 to filter the table visual to display the [Type])="Bundle"  by putting the Filter1 in the Visual Level Filter of table visual ,setting Filter1 as "is not blank".

 

Count Clients = CALCULATE(DISTINCTCOUNT(Table1[Clients]),FILTER(Table1,Table1[Type]=MAX(Table1[Type])&&Table1[Clients]=MAX(Table1[Clients])&&MONTH(Table1[Date])=MONTH(MAX(Table1[Date]))))

 

Filter1= IF(MAX(Table1[Type])="Bundle",1,BLANK())

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    it doesnt worked. Please help with other logic

     

    REgards,

     

     

    • v-xicai's avatar
      v-xicai
      Community Support
      7 years ago

      Hi Anonymous ,

       

      Could you please show me the error information form my pbix file? 

       

      For the error as you said above :

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

       

      To work around the issue ,you can check if missing brackets ")".

       

      Or could you please share your sample data or screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

       

      Best Regards,

      Amy