Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Column total and HASONEVALUE

Hi,  I have this measure that is calculating the row total (per counterparty) based on another measure [P/L].      However, the column total is wrong so how can I include the date dimension ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , remove if and hasonevalue code and just try sumx(Value(.....)  code

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi amitchandak ,

     

    Apparently the HASONEVALUE was not needed, the row subtotals are correct with it removed, but the column subtotal is still wrong i.e I get the same result.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous ,

       

      As far as I know, column subtotal is based on the column in Matrix column field (MonthName). So here I suggest you to add the whole table in SUMX().

      Measure = SUMX(TransactionDaily,[P/L])

      My Sample:

      P/L = MAX(TransactionDaily[Value])

      If I use the measure as yours above, I will get same error in column subtotal. If I use mine, it works. Result is as below.

       

      Best Regards,
      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Anonymous , thanks for your input.

        The measure [P/L] is calculated using values from two different tables.

        As in this simplified example, volumes from one table and prices from another table.

         

        Measure for the total   

        P/L and P/L Total shows both wrong totals.