Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Percentile

Hi I have a large dataset in which I need to calculate percentile for each sub catogeory has 3 diffrent metric  If I do it one by one it will make 90 different column.   Is there a way to calutake...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    Try it.

    Percentile For data 1 =
VAR K_Perc =
    IF ( HASONEVALUE ( parameter[parameter] ), VALUES ( parameter[parameter] ) )
VAR category =
    MAX ( consol[Case CategoryCase TypeCase SubtypeCase Owner SiteCase Language] )
RETURN
    CALCULATE (
        PERCENTILE.INC ( consol[Case First Touch Cycle Time], K_Perc ),
        FILTER (
            ALL ( consol ),
            [Case CategoryCase TypeCase SubtypeCase Owner SiteCase Language] = category
        )
    )

    If this is not correct, please share your simple file and the results you want to output.It makes it easier to give you a solution.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous；

 

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.