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

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Cool machi .

 

1. Don't use summarize function it will create performance issue. my suggestion is go with ADDColumn.

 

or if u want summarize u can go with that, i will help u .

 

Solution :

 Filter( Summarize ( here ur stuffs whatever u have already  ) ,  entry_type=1)

 

This will work if not let me know machi i will help u .

 

I hope u r from Tamil Nadu.

 

 

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