Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Percentile and Count

Hi all, 

I have a table consisting of a column dates and associated number of movements.

I've been able to calculate the 95th percentile, now i'm looking to count the number of dates which have movement greater than or equal to the 95th percentile per year.

 

I've created the 95th percentile as a new measure which works and tried then creating a new measure to count referencing the percentile column. 

 

Is anyone able to point me in the right direction please? 

 

Thanks,

 

Philip

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Hello @Anonymous 

You will need a measure that calculates the total movement which I assume you have.  Give this a try.

Dates over 95th percentile =
CALCULATE (
    COUNTROWS (
        FILTER (
            DISTINCT ( 'YourTable'[Dates Field] ),
            [Total Movement] > [95th Percentile]
        )
    )
)

View solution in original post

1 REPLY 1
jdbuchanan71
Super User
Super User

Hello @Anonymous 

You will need a measure that calculates the total movement which I assume you have.  Give this a try.

Dates over 95th percentile =
CALCULATE (
    COUNTROWS (
        FILTER (
            DISTINCT ( 'YourTable'[Dates Field] ),
            [Total Movement] > [95th Percentile]
        )
    )
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.