Forum Discussion

rcaeiro's avatar
rcaeiro
New Member
5 years ago
Solved

Matrix column subtotal don't show values

Hello 🙂   I'm doing a matrix table, with one date by column, a date by row and a calculated measure in values: I'm having a problem with the total by column, the value is not showing. The m...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi rcaeiro,

     

    Try measure as:

    Measure = 
SUMX(VALUES(TableA[CONTRACT_MONTH]),[Stock1])

    Here is the output:

     

     

    Best Regards,

    Link

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi rcaeiro,

 

Try measure as:

Measure = 
SUMX(VALUES(TableA[CONTRACT_MONTH]),[Stock1])

Here is the output:

 

 

Best Regards,

Link

  • rcaeiro's avatar
    rcaeiro
    New Member
    5 years ago

    Thank you v-xulin-mstf that solution solved my problem. 😁