Applying values to just one column (DAX)

luizfjr00 — Wed, 09 Aug 2023 13:28:51 GMT

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.

topic Applying values ​​to just one column (DAX) in DAX Commands and Tips

Applying values ​​to just one column (DAX)

topic Applying values to just one column (DAX) in DAX Commands and Tips

Applying values to just one column (DAX)