Dax filter column in column

[nontmn]

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 model.

but (ZGI[model])=ZGI[model] not working in column 

PS. I have to use in column not measure because I will use this column next.

Thank you

[Zubair_Muhammad]

@nontmn 

Try following

=
CALCULATE (
    SUM ( ZGI[sale] ),
    FILTER ( ZGI, ( ZGI[model] ) = EARLIER ( ZGI[model] ) )
)

[nontmn]

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

[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

https://community.powerbi.com/t5/Desktop/join-two-tables-and-find-min-after-doing-group-by/m-p/76893...

[nontmn]

I use 

column1 = CALCULATE (SUM ( ZGI[sale] ),FILTER ( ZGI, ( ZGI[model] ) = EARLIER ( ZGI[model] ) ))

and next I create column 2 like this

column2 = CALCULATE (SUM ( ZGI[GI] )

It show "a circular dependency was detected:ZGI[GI],ZGI[sale],ZGI[GI]" 

[Zubair_Muhammad]

@nontmn 

I don't see any error in your formula

Could you share your file?

What are you trying to achieve with

column2 = CALCULATE (SUM ( ZGI[GI] )

if your Table rows are different then above formula and column2 = ZGI[GI]  would yield same results

[nontmn]

https://1drv.ms/u/s!AqosNctB7VSarCPtoiEg786KxV_h?e=B3rWp9

I create new file to compare issue at "Column 4"

[Zubair_Muhammad]

@nontmn 

I checked your file.
What is your desired output in Column 4?

[nontmn]

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 · Accepted solution]

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.