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 

 

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

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

    nontmn 

     

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

     

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