Forum Discussion

israelfc92's avatar
israelfc92
Regular Visitor
2 years ago
Solved

Column subtotals do not add up

Hello, I hope you can help me. I have a matrix made through measurements and two levels that does not fit in the subtotals by columns. I already squared the subtotals at the row level. I'm just missing this, thanks for the help.

 

Measure

Matrix

 

Tips and Tricks
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    hello israelfc92 ,

    try changing your code to the following : 
    calculate(
    sumx(
    values(ventas[ID EMPRESA]),
    calculate(
    sumx(
    values(fechas[año-mes]),
    round([measure]/ 10000, 0)
    )
    )
    )
    )

     

    if you do not have a column in date table  "year-month", you can create it easily with a calculated column

     

     

    let me know if this works for you. 

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion
    2 years ago

    hello israelfc92 ,

    try changing your code to the following : 
    calculate(
    sumx(
    values(ventas[ID EMPRESA]),
    calculate(
    sumx(
    values(fechas[año-mes]),
    round([measure]/ 10000, 0)
    )
    )
    )
    )

     

    if you do not have a column in date table  "year-month", you can create it easily with a calculated column

     

     

    let me know if this works for you.