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

Hi  Anonymous 

Thanks for reaching out to us.

the YoY% in 2022 was more than 10% (16% as you see below),  so the [Deductions % per Scheme] should be 18% each row right? The reason for this error, I think it may be that the called [YoY% in 2022] is incorrect when calculating [Deductions % per Scheme]  in each row, please try to change the measure to return YoY% in 2022

Best Regards,

Community Support Team _Tang

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