Forum Discussion
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...
Just to be clear:
As you can see in the below measure 'Deductions % per SchemeV2":
Deductions % per SchemeV2:=iferror(sumx(summarize(cust1,CUST1[Buying Group2]),
IF(calculate([YoY% XX],CUST1[Buying Group2]="Blue Vet")>0.1,0.18)),0)
Screenshot for your convenience-
See below that I have the 0.18 show up every time the YoY% is above 10% on a customer level. Can you help me understand what I need to change in the measure above so that 0.18 shows up all the time because the entire group is performing at *16%* (more than 10%)?
Thanks!