Conversion of calculated column to Measure

[pers]

Hello, I am new to DAX and Power BI. I am trying to convert a calculated column into a measure so that I am able to use the measure with slicers, as slicer does not work on calculated column (or maybe I am not aware).

The value of calculated field is based on checking the value of first column, and then computing using other two columns.

CalculatedColumn = IF(AND(Table[Account]>"111111", Table[Account]<"222222"),-Table[D]+Table[C],Table[D]-Table[C])

I am not able to convert this into a measure. Any help/ direction is highly appreciated.

[Anonymous]

I have a similar issue...

Basically want to convert this calculated column into a measure.

Tried using 

Delivered Savings Measure =
VAR DelStatus = SELECTEDVALUE('Table 1'[Stage of Delivery])
Return

SWITCH(TRUE(),
DelStatus = "Completed" , 'Table 1'[Estimated Overall Saving] ,
DelStatus <> "Completed", 'Table 1'[Saving Delivered to date]
)

But it didn't give me the right figures, is anyone able to help please?

Thanks 

[v-juanli-msft · Accepted solution]

Hi @pers 

Try this measure

MEASURE =
IF (
    AND ( MAX ( Table[Account] ) > "111111", MAX ( Table[Account] ) < "222222" ),
    - MAX ( Table[D] ) + MAX ( Table[C] ),
    MAX ( Table[D] ) - MAX ( Table[C] )
)

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TCarrasquillo]

I believe the measure would just look like this:   CalcColumnMeasure = Sum ( 'Table' [Calculated Column] ).

If you still want to do a measure 🙂

[HotChilli]

It's the other way round, slicers like calculated columns