Forum Discussion

sabd80's avatar
sabd80
Icon for Helper IV rankHelper IV
1 year ago

Wrong Column Totals

Hi, My issue is the Column Totals is wrong, the row total is correct, it shows the value of the Max 'Calendar'[Simplot_Month_Relative]. this the measure: Testing2 Actual vs Forecasts $ = VAR Mont...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi sabd80 

 

Try creating a new measure that sums the row by row evaluaiton of those period columns.

SUMX ( VALUES ( 'table'[period column] ), [your measure] )
  • sabd80's avatar
    sabd80
    Icon for Helper IV rankHelper IV
    1 year ago

    danextian  the row total is correct, but the column totals is wrong.

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      1 year ago

      The SUMX measure i provided is only to evaluate horizontally on the period column being used. It is not supposed to change the total on the total row.

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, sabd80 
      Thanks for reaching out to the Microsoft fabric community forum.

      Could you please clarify how your matrix is constructed? For example, are the columns in the matrix from the same table or from related tables? Additionally, how are your Cases Forecast and Cases Actual measures defined? Understanding these details will help us analyze and provide a more feasible solution to your issue.

       

      Of course, you can also try using the ISINSCOPE() function or the HASONEVALUE() function to determine the row total part and then adjust your logic accordingly.

       For further details, please refer to:

      Dealing with Measure Totals - Microsoft Fabric Community

      Measure Totals, The Final Word - Microsoft Fabric Community

       

      I hope you can answer my questions, and I look forward to your response.

       

      Best Regards,

      Leroy Lu