Forum Discussion

sa1's avatar
sa1
Frequent Visitor
9 years ago

Conditional Top 5

I have a table with an attribute ‘A’ for a given day with numerical data. I have calculated its value for the previous day – measure ‘B’ using the DATEADD function. The delta between A AND B has been calculated (with the signs). The absolute value of the delta has been computed. I need to get the top 5 values of attribute ‘c’ based on absolute delta(it’s magnitude) . However, there should never be a case where all of the 5 values have a positive change (or a negative change).If the top 4 values are positive then the fifth has to be negative and vice-versa. Note: Measures B, and delta change dynamically with the date slicer.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Sounds like a measure based upon TOPN but not sure about the all positive or negative aspect of it. Would have to think about that.