Forum Discussion

NilR's avatar
NilR
Post Patron
4 years ago

Wrong Total FOR Addcolumns(Summarize())

I have two measures, but the second one returns wrong total. I added AddColumns to optimize the query. Any suggestions would be great. Thanks!  
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi NilR ,

 

I have a little trick to help you see the current tables created by summarize.

 

test =
VAR _s =
    SUMMARIZE (
        'table',
        [column1],
        [column2],
        "newcolumn1", [measure1],
        "newcolumn2", [measure2]
    )
RETURN
    CONCATENATEX (
        _s,
        [column1] & " " & [column2] & " " & [newcolumn1] & " " & [newcolumn2],
        "
"// here please enter "alt+enter" as <delimiter> 
    )

 

If you need more help, please share your pbix without sensitive data.

 

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.