Forum Discussion

pers's avatar
pers
Frequent Visitor
7 years ago
Solved

Conversion of calculated column to Measure

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.

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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.

4 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    7 years ago

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

  • TCarrasquillo's avatar
    TCarrasquillo
    Icon for Helper II rankHelper II
    7 years ago

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

     

    If you still want to do a measure :)

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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