Forum Discussion

nayan28apr's avatar
nayan28apr
Icon for Helper I rankHelper I
5 years ago
Solved

Issue with Row Subtotal and individual rows values sum is not matching in metrix for same formula.

Hi,   I am facing issue to get correct formula response in matrix at each drill down level.   What I found is sum of a, b, c columns are right at my first level and second level of drill down. Al...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • nayan28apr's avatar
    nayan28apr
    5 years ago
    Thank you very much.

Measure=
VAR summarytable = SUMMARIZE('Table',[Segment],[Franchise],[Cluster],[weekno],"_value",[Sales])
Return

SUMX(summarytable ,[__value])

This formula finally worked for me, I need to use all columns in summarize.
I have than used AddColumns with Summarize to find best performance out of it as Summarize was giving me performance issues.

Measure=
VAR summarytable = AddColumns(SUMMARIZE('Table',[Segment],[Franchise],[Cluster],[weekno]),"_value",[Sales])
Return
SUMX(summarytable ,[__value])


Overall I have stopped row subtotal calculation (a/b)*c which was not working for me. Instead used individual rows sum and showing at the subtotal rows.