Forum Discussion

subzero355's avatar
subzero355
Frequent Visitor
4 years ago

Dynamic Segmentation not working based on measure

I have below table,

 

Classification2 = if(ctblABC[Temp] < 0.5,"A","B")
Can't understand why Classification2 is showing "B" instead of "A" for values in Temp < 0.5
Need Help

2 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi subzero355 ,

     

    What is the formula for ctblABC[Temp]?

     

    And not sure if this measure fits your context, maybe you can try it.

     

    Measure =
IF (
    SUMX (
        SUMMARIZE ( 'Table', 'Table'[Material], "_temp", [Temp] ),
        [_temp]
    ) < 0.5,
    "A",
    "B"
)

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • subzero355's avatar
      subzero355
      Frequent Visitor
      4 years ago

      Here is how Temp is calculated,

      Temp =
      var CurrPercentage = ctblABC[Contribution]
      RETURN
      (
      sumx(filter(all(ctblABC[Material]),ctblABC[Contribution] >= CurrPercentage),
      [Sales_6M]/[Sales_Total]
      )
      )