Forum Discussion

ThomasDay's avatar
ThomasDay
Impactful Individual
10 years ago

Percentile category

Hello again,   I'm looking to compute the percentile breaks in a visualization (filtered) table dynamically--change the slicer, things change...and then classify each row into a percentile category...
Sean's avatar
Sean
Community Champion
10 years ago

eljustino

How do you get overall TotalProfitMargin in the bottom row of 81.09%???

 

In the sample I created I get 40.98% 

eljustino's avatar
eljustino
New Member
10 years ago

Sean Ah, yeah... that's actually the MAX (used MAX for my simple measure). Probably should've just removed that, but I wasn't paying attention.

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    Okay I didn't think about this - that makes sense now!

    • ThomasDay's avatar
      ThomasDay
      Impactful Individual
      10 years ago

      Yes, the typo nailed me...I stared at that for a long time and figured it out...then tried to remove my post so not to bother folks.  Anyway, it worked great, eh?

      • pat_energetics's avatar
        pat_energetics
        Advocate II
        10 years ago

        Further to this example, is there a way of using a measure result directly in the "K" argument of the percentile function?

         

        Where in the following example; 'Band' is a 10 row table with columns [BandNumber] of values 1-10 and [K Perc] of values 0, 0.1, 0.25, 0.45, 0.5, 0.55, 0.75, 0.9, 0.95, 1

         

        eg K Perc Result := IF(HASONEVALUE(Band[K Perc]),VALUES(Bands[K Perc]),0.5)

         

        PercentileBandResult:= CALCULATE

        (PERCENTILEX.INC(FactTable, FactTable[Column],[K Perc Result]), // other filters, //)

         

        or should a VARiable be used within the measure to explicitly return a value to the percentile function e.g

        VAR
        KValue = IF(HASONEVALUE(Band[K Perc]),VALUES(Band[K Perc]),

        SWITCH (Band[K Perc],

        "0" = 0,

        "0.1" = 0.1,

        etc,

        etc,

        "1" = 1,

        //if all the above fail //,0.5)
        RETURN

         

        PercentileBandResult:= CALCULATE

        (PERCENTILEX.INC(FactTable, FactTable[Column],KValue, // other filters, //)