Forum Discussion
Helper IDax filter column in column
Hello,
I would like to Sum sale by filter other like this
Hi nontmn ,
Based on your original formula, I modified it to calculte the values.
Column 4 = DIVIDE(CALCULATE(SUM('Table'[A]),FILTER('Table',EARLIER('Table'[model])='Table'[model])),'Table'[A])Is this what you want? If not, can you please post the expected result? Then we will understand your requirement clearly.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 Replies
- Zubair_Muhammad
Community Champion
Try following
= CALCULATE ( SUM ( ZGI[sale] ), FILTER ( ZGI, ( ZGI[model] ) = EARLIER ( ZGI[model] ) ) )
nontmnThank you It's working but when I use in another column for sum another thing it show
"a circular dependency was detected"
I have to make fomular like this for 3 column
Please help
Thanks
- Zubair_Muhammad
Hi nontmn
What formula did you use?
If you could copy paste some sample data and expected results, it will help in finding an appropriate solution
As a sample see the below post
