Percentile

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.