Forum Discussion

Vinothsusai's avatar
Vinothsusai
Icon for Helper III rankHelper III
6 years ago

Unable to summarize the matrix table column same values in the cell (DAX)

Hi, I have a final matrix table combining two tables. Is it possible to summarize the matrix table column(Vendor Main Account Meas) same values in a cell.   Customer Account Vendor Account Cu...
Interesting Links
Need Help
v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Please try to create a measure by using 'SUM' to calculate the sum of [Customer Amount].

 

Best Regards,

Giotto Zhi

  • Vinothsusai's avatar
    Vinothsusai
    Icon for Helper III rankHelper III
    6 years ago

    Thank you for your reply.

    Actually these multiple  customer amounts are in a single cell. Like that we have multiple customer amounts, Customer Main accounts,vendor Mainaccounts and vendor amounts. How can we summarize this by Customer main accounts and vendor main accounts.

     

    Please advise.

     

    Thanks

    Vinoth

      • Vinothsusai's avatar
        Vinothsusai
        Icon for Helper III rankHelper III
        6 years ago

        Hi,

        Thank you for your reply.

        Could you please advise in the DAX. We have built this data from measures and we would like to fix this in dax. Is it possible to do that.

         

         

        Thanks

        Vinoth SUSAINATHAN