Wrong Total FOR Addcolumns(Summarize())

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.

NilR , move filter inside the measure and check

 

CALCULATETABLE(
ADDCOLUMNS(SUMMARIZE('PHA', '0PHA'[CNSR_INDV_ID]),
"_BIOM", 0,
"_PHA",0,
"_CTC",CALCULATE(SUMX(values('0630 BIOMPHA'[ENRL_DATE]),MAX('PHA'[CTC]),
FILTER('PHA',([ENRL_DATE]>= Min_Date && [ENRL_DATE]<= Max_Date) && [GP_NB]=_gpnb
&& [CTC] >0))) ) )