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.

     

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

Actually, I have many version for one model so sometime I cannot indicate version, it has to share to other version.

My idea is create column that already shared sales by month and model but when I create another column with same method it show circular dependency detected(sum column[A]).

I already use measure method to share version but I found something wrong (subtotal sum up) . So I think it better to share before next calculation by measure.

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
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.