Forum Discussion

nontmn's avatar
nontmn
Icon for Helper I rankHelper I
7 years ago
Solved

Dax filter column in column

Hello, I would like to Sum sale by filter other like this CALCULATE(SUM(ZGI[sale]),FILTER(ZGI,(ZGI[model])=ZGI[model])) I would like model from that row will filter other out and sum only this mo...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    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.

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

nontmn 

 

Try following

 

=
CALCULATE (
    SUM ( ZGI[sale] ),
    FILTER ( ZGI, ( ZGI[model] ) = EARLIER ( ZGI[model] ) )
)
  • nontmn's avatar
    nontmn
    Icon for Helper I rankHelper I
    7 years ago

    Thank 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