Forum Discussion
nayan28apr
Helper I
Helper IIssue 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...
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.
HI nayan28apr,
Can you please provide a pbix file with some dummy data and keep the raw table scheme? It should help us clarify your sicario and test to coding formula on it.
How to Get Your Question Answered Quickly
Notice: please not attach the sensitive data in the sample file.
Regards,
Xiaoxin Sheng
nayan28aprHelper I
Helper IThank 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.