Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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] ) ) )
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] ) ) )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |