Forum Discussion

tlamoureux's avatar
tlamoureux
Frequent Visitor
6 years ago

Dynamic segmentation

Hello, I am trying to give a chance to PowerBI and so I'm migrating the most representative of my Qlik Sense report. I am facing an issue with something I call here dynamic segmentation. My report...
Need Help
  • tlamoureux's avatar
    tlamoureux
    Frequent Visitor
    6 years ago

    Hello,

    Thank you for your answer but I have already found this thread and it does not help.

    Here is a simple illustration of what I need.

    If query2 is composed of these elements :

    ShodIDShopNameDate

    Rank

    1Toulouse01/01/20198
    1Toulouse02/01/20198
    1Toulouse03/01/20198
    1Toulouse01/01/20209
    1Toulouse02/01/20209
    2Nice01/01/20196

     

    If I apply no filter, I will have this result

    RankNumber Of Shop
    00
    10
    20
    30
    40
    50
    61
    70
    81
    90

    Then, if I apply the filter Year=2020, the result will be :

    RankNumber Of Shop
    00
    10
    20
    30
    40
    50
    60
    70
    80
    91

    First I calculate the aggregation on the average in the time periode and then I apply the floor function to obtain the rank.

    Thanks for help.

    Thierry

    • tlamoureux's avatar
      tlamoureux
      Frequent Visitor
      6 years ago

      Hi,

      I'm still stuck with this problem. Can someone help ?

      Thank you very much,

      Thierry.

      • tlamoureux's avatar
        tlamoureux
        Frequent Visitor
        6 years ago

        Hello,

        I've found by myself but I still have some question. I used this thread with the bellow DAX formula :

        Segmented stores =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( Data[StoreID] ),
            "ABCD",
            CALCULATE (
                [Total sales],
                CALCULATETABLE ( VALUES ( Data[StoreID] ) ),
                ALLSELECTED ()
            )
        ),
        COUNTROWS (
            FILTER (
                Buckets,
                [Total sales] >= Buckets[Lower]
                    && [Total sales] <= Buckets[Upper]
            )
        ) > 0
    )
)

        I've two questions, the first is about the CALCULATE, I don't understand why the VALUES(Data[StoreID]) is in the CALCULATETABLE function. If I only put the VALUES function it does not work but I do not see the difference as there is no argument for CALCULATETABLE. Then, I do not understand the goal of the ALLSELECTED(), if delete this line, I have the same result.

         

        I have inserted in my report this bar graph :

        The value are exactly what I expected but, when I click on a bar, the other element of my report are not updated : if I click on the bar "0 à 1", the list of shops may be reduced to a number of 5. Do you have an idea why it does not work ?

         

        Thank you very much,

        Thierry