Forum Discussion
Sum If calculation problem
Dear all, I have trouble sutting my formul to have a sum the take into consideration my filters : Simul2 = if(Region[Opportunity type]="Simul"; CALCULATE(sum(Region[Value Impact]); filter(Re...
Hi Simondeb ,
According to your description, it seems that you are creating calculated column, and it seems that you want to use filter and slicer to control its value, right?
As I know, we can't use slicer and filter to control calculated column' value. So you need to use measure to achieve this goal. By the way, if possible, could you please inform me more detailed information(such as your expected output and your sample data, you could upload virtual data instead of real data as sample)? Then I will help you more correctly.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.