Forum Discussion

kennylch's avatar
kennylch
Helper I
2 years ago

new column based on measure value

Below is the sample data extracted from my matrix table.    The measure column created using this. it gives the correct value as expected as well as conditional formatting with right colour shade. ...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi kennylch - you can create a measure instead of calculated column 

ex: as per data

Healthy Level =
IF(
[Measure] < 0,
"Unhealthy Level",
IF(
[Measure] < 5,
"Healthy Level",
"Above Healthy"
)
)

Hope it helps

kennylch's avatar
kennylch
Helper I
2 years ago
Hi. It doesnt help as this invole 2 table.. Once i insert a measure like this. My other measure became blank
  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi kennylch - you can create measure logic in calculated column, using related function to the data.

    Measure_Column =
    ([Net Qty] - RELATED(OtherTable[Req Qty])) / RELATED(OtherTable[Req Qty])

     

    and then use the create calculated column provided as below:

    Healthy Level =
    IF(
    [Measure_Column] < 0,
    "Unhealthy Level",
    IF(
    [Measure_Column] < 5,
    "Healthy Level",
    "Above Healthy"
    )
    )

     

     

    hope it helps