topic Re: How to write a measure to calculate 5th percentile in DAX Commands and Tips

How to write a measure to calculate 5th percentile

Cevola — Mon, 17 Jul 2023 14:14:05 GMT

Hi,

I want to write a measure to calculate 5th percentile of the VALUE column. I am new to Power BI

Please help

baghdadi62 — Mon, 17 Jul 2023 16:43:09 GMT

Hi,

PERCENTILE.INC('YourTableName'[VALUE], 0.05)

Cevola — Mon, 17 Jul 2023 16:47:39 GMT

Hi, I have written this measure but when I pull this measure in the visualisation I get the values same as in the VALUE column

baghdadi62 — Mon, 17 Jul 2023 16:58:46 GMT

Create a measure and use it in a Card visualization in this format, and let me know if there is any issue.

Cevola — Mon, 17 Jul 2023 17:03:22 GMT

It works in the Card, But can I get a new column PERCENTILE

Anonymous — Tue, 25 Jul 2023 02:40:06 GMT

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create measures.

Per = PERCENTILE.INC('Table'[Value],0.05)

Per_V = CALCULATE([Per],ALL('Table'))

(3) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.