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 mayb...
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.

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.