Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a logical parameter with Summarize?

Hi,   I want to give customers a certain % of deduction if ALL the customers within that group meet a specific YoY (year over year) criteria of revenue growth.   So for example, the measure below...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

What are the additional conditions of "Blue Vet" and "LL"?  When do the other discount % of 15%, 21% and 0% kick in?  Please explain in detail.  Also, share the link from where i can download your PBI file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ashish the conditions are the ones I share in the measure which I present. Nothing else.

    It's a group of 18 customers to which you can see each is growing at a certain YoY. The Condition I wish to be in place is only if all 18 grow at a YoY which is higher than 10% (see the measure) then they will get 18% deduction. There is also another condition relating to the LL which would come on top but that is individually based per customer. That one is working well as you can see... it's more about linking the accumalative YoY growth of all 18 customers which I'm struggling.

     

    I cannot share the PBI unfortunately.

     

    Thanks,

    Eyal

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      I will a file to work with.  Anonymise the data in your file and share the download link.