Forum Discussion

MiguelSaldana77's avatar
MiguelSaldana77
Icon for Resolver I rankResolver I
8 years ago
Solved

summation Total on Colum

Hi,  I have a problem with a total of the Visual Matrix   I have a table that calculate the result of a colum ("PO Importe") , but I don´t want that this formula applies to the TOTAL. The TOTAL mus...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi MiguelSaldana77,

     

    You should use a SUMX to make the calculations on this:

     

    Total =
IF ( HASONEVALUE ( Table[Obra] ); [Po Importe]; SUMX ( Table; [Po Importe] ) )

    Should work as expected.

     

    Then replace the PO Importe by this one.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi MiguelSaldana77,

 

You should use a SUMX to make the calculations on this:

 

Total =
IF ( HASONEVALUE ( Table[Obra] ); [Po Importe]; SUMX ( Table; [Po Importe] ) )

Should work as expected.

 

Then replace the PO Importe by this one.

 

Regards,

MFelix

  • MiguelSaldana77's avatar
    MiguelSaldana77
    Icon for Resolver I rankResolver I
    8 years ago

    Thanks MFelix , but was enought with a simple    SUM()  of the calculated Measure