Applying values ​​to just one column (DAX)

[luizfjr00]

Hi everyone.

I need help to apply the values of a measure TestApportDefense to just one Column. Currently, the measure is being apply to all columns e i would like to apply just on column "312 Colombia", in another words, to the others columns, the measure TestApportDefense must be blank values.

The measures that i am using can be view just below:

TestApportDefense = CALCULATE(

    [_MED_TOTAL_USD_APPORT_DEF],

    FILTER(

        ALLSELECTED(d_DeParaProgram),

        d_DeParaProgram[Program EN] = "312 Colombia"

    )

)

_MED_TOTAL_USD_APPORT_DEF =

CALCULATE(

                                    -CALCULATE(SUM(f_CSI_GFG_BI_TAX_SEG[NUM_APPORT_DEF]), FILTER(ALL(d_DeParaSegment),

                                        d_DeParaSegment[Segmento EN] = "Todas" ||

                                        d_DeParaSegment[Segmento EN] = "Todas não CL" ||

                                        d_DeParaSegment[Segmento EN] = "RATEIO PORTUGAL")

                                    ),FILTER(ALL(d_DeParaProgram),d_DeParaProgram[Program EN]="Apportionment" ||

                                                d_DeParaProgram[Program EN]="Apportionment Portugal")

                            )

I could not change anything in [_MED_TOTAL_USD_APPORT_DEF] because there are somethings that will be broken and the use of IF Statement, for this purpose, slows down the measure.

Thanks in advance.