Percentile calc to remain constant on day but update on dimension filter use

[FOXYBARK]

HI there. 

Here is my table of data. 

Here is my proposed calc. I crafted this from another Fabric post. This calc works but does not provide my desired number. 

I am trying to get the 90th percentile for each floor. THis needs to remain constant across days. [PeopleCounts] are simply SUM(VALUE). 

Below is my ideal output. A constant line - 90th percentile line across days for each floor when I use a floor slicer. 

Thanks, F

[v-kpoloju-msft]

Hi @FOXYBARK,
Thank you for reaching out to the Microsoft fabric community forum.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.    

Dax Measure for Creating 90^th Percentile:

90th Percentile =

IFERROR(

    PERCENTILEX.INC(

        CALCULATETABLE(

            'August Badge Data',

            REMOVEFILTERS('August Badge Data'[Date])

        ),

        'August Badge Data'[Value],

        0.9

    ),

0)

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[FOXYBARK]

Hi there @v-kpoloju-msft Thank you for this. There is one added layer to this and I made the small modification in your sample workbook. I'd like the values summed by day and then the percentile calculated off the summed values. For example, now the 5th floor, 90th percentile is 31.4. Correction: I cannot attach the .pbi file so here are some screenshots of what I did. How would you modify your calculation to account for this please?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...