Add new colum calculate

[ASB]

Hello,

I have diferents tables from xlsx files, the main table contain a colum with text only data.
I create this measure: DATA01 = -CALCULATE(SUM(Detail[ColumBAL] );TREATAS({("Text_Data01")}; 'Detail'[Column1])) to extract the data if in the colum have this text "Text_Data01"

How can i create new colum creating the SUM automaticaly? i try to use the same formula but is not working....

thanking in advance

[v-yulgu-msft · Accepted solution]

Hi @ASB,

Please try to modify the formula as below to create a calculated column.

Text_Data =
CALCULATE (
    SUM ( Detail[ColumBAL] ),
    ALL ( Detail ),
    TREATAS ( { ( "Text_Data01" ) }, Detail[Column1] )
)

Best regards,
Yuliana Gu