Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Helper V
9 years ago
Solved

Issue in the filter

    I am tryinmg to summerize the amount in my data on the basis of entry type=1 but when i am applying the filter i am facing this issue as i shown, If their is any mistake in my code please make...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Satish_Kumar，

    >> if Doc.No Xxxxx having multiple Payment, the result should show the value =15000 gainst the Doc No Xxxxx.

    10000 1st
    2000   2nd
    3000  3rd
     
    I create the sample data and create a new table using the formula.

     

    Table 2 = SUMMARIZE(Table2,Table2[Type],"Amount",SUM(Table2[Doc]))


    As shown in the snapshot, it will return the desired result about sum of “Doc” group by “Type”.

     



    Based on my understanding, do you want to calculate the sum of amount for “Entry Type”=1 group by Document No_, Posting Date, Entry Type, right? If it is, I try to reproduce it using your given sample data.

    Create a new table using the formula below, and get expected result shown the screenshot.

    Table = SUMMARIZE(Table1,Table1[Document No_],Table1[Posting Date],Table1[Entry Type],"Invc Amount",CALCULATE(SUM(Table1[Amount]),Table1[Entry Type]=1))

     
    If you have any other issue, please share more details.

    Best Regards,
    Angelia

Satish_Kumar's avatar
Satish_Kumar
Helper V
9 years ago

Baskar

I am creating a new table for that i need a DAX formula.

And if i am not wrong then addcoloumn will fail in that i just want to know that why this is giving me opposite result.

 

And i am from Delhi dude i lived in tamil 2 year back .

 

Regards,

Satish Kumar 

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Can u please share ur formula , it is not clear in that image .

    • Baskar's avatar
      Baskar
      Resident Rockstar
      9 years ago

      Cool dude,

       

      First u could under stand the logic what u did .

       

      based on your Summarize function it is correct result .

       

       

       

      see the condtion u have applied in new column level then how it will work at table level ?

      make sense.

       

       

      if u want only Entry type =1 

       

      add filter in front of Summarize and apply filter where entry type = 1

       

      example :

       

      Filter (  Summarize(............), Entry_Type =1 )

       

      it will help u, let me know if any help.

      • Satish_Kumar's avatar
        Satish_Kumar
        Helper V
        9 years ago

        Baskar

        I have did that Baskar but at the end the summerize donot giving the correct value.

        For Example-

        if Doc.No Xxxxx having multiple Payment

        10000 1st

        2000   2nd

        3000  3rd

         

        the result should show the value =15000 gainst the Doc No Xxxxx

         

        But its is not giving the correct it only shows the value i.e. 10000