Create a new table from the Main Table with criteria

You can use below DAX code to calculated table

ResultTable =

VAR ClientsCountries =

    SUMMARIZE(MainTable, MainTable[Client], MainTable[Country])

VAR Items =

    VALUES(MainTable[Item])

RETURN

    GENERATE(

        ClientsCountries,

        ADDCOLUMNS(

            Items,

            "AmountSold",

            CALCULATE(

                SUM(MainTable[AmountSold]),

                FILTER(

                    MainTable,

                    MainTable[Client] = EARLIER(MainTable[Client])

                        && MainTable[Country] = EARLIER(MainTable[Country])

                        && MainTable[Item] = EARLIER(MainTable[Item])

                )

            )

        )

    )

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Thanks pankajnamekar25 for the quick reply.  By switching [AmountSold] to "Don't Summarize" does the trrick.  How can I convert the blanks to a zero or even text?  Thank you again. 🙂

Edit: Please ignore. I changed this line of code: 

Thanks again. 🙂 P.S. I may be back lol!