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.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

I don't immediately see anything wrong with what you wrote (other than the comma inside VALUES). Can you explain what you mean by "doesnt seems to be working"? What results are you getting and what do you expect to get?

 

It appears you might be trying to define this as a calculated column. Calculated columns cannot read slicer values since they are only calculated once (each time the data model is loaded or refreshed) rather than in response to user interaction. To be able to read an input parameter that the user selects, you'll need to define a measure instead of a calculated column