topic Re: STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently? in DAX Commands and Tips

STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently?

MarcoMazzocco — Mon, 30 Jun 2025 12:19:07 GMT

Hi...STDEVX works without a table function while PECENTILEX.INC forces me to use a table function like SUMMARIZECOLUMNS in order to get the correct result. Is there a mechanical difference in how the functions operate?

Re: STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently?

bhanu_gautam — Mon, 30 Jun 2025 12:33:31 GMT

MarcoMazzocco

The mechanical difference lies in the requirement of a table context for PERCENTILEX.INC to evaluate the entire dataset correctly, whereas STDEVX can operate directly on a column or an expression without needing an explicit table context.

DAX
// Using STDEVX directly on a column
StandardDeviation = STDEVX(VALUES(Table[Column]), Table[Column])

// Using PERCENTILEX.INC with SUMMARIZECOLUMNS to provide the correct context
Percentile = PERCENTILEX.INC(SUMMARIZECOLUMNS(Table[Column]), Table[Column], 0.5)

In the PERCENTILEX.INC example, SUMMARIZECOLUMNS is used to create a table context that includes the values from Table[Column], allowing the function to calculate the percentile correctly.

Re: STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently?

v-sshirivolu — Tue, 01 Jul 2025 05:28:20 GMT

Hi MarcoMazzocco ,

Thanks for reaching out to the Microsoft fabric community forum.

STDEVX.P works directly with a table, but PERCENTILEX.INC needs a table expression like VALUES() to function correctly. The attached .pbix file shows this difference using SalesData and three measures.

Doesn't work reliably:

PERCENTILEX.INC(SalesData[Sales], SalesData[Sales], 0.9)

Works properly:

PERCENTILEX.INC(VALUES(SalesData[Sales]), SalesData[Sales], 0.9)

Please find the below attached .pbix file for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team

Re: STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently?

MarcoMazzocco — Wed, 02 Jul 2025 11:34:18 GMT

Thanks !!

Re: STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently?

MarcoMazzocco — Wed, 02 Jul 2025 11:43:29 GMT

This helps expalin the logic for sure. There seems to be an issue still since I'm using a measure instead of a column as the expression to evaluate. PERCENTILEX.INC(VALUES(table), [Measure],0.9) Does a measure change the behavior?

Re: STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently?

v-sshirivolu — Mon, 07 Jul 2025 04:46:16 GMT

Hi MarcoMazzocco

Absolutely, using a measure directly in PERCENTILEX.INC impacts its behaviour. For instance -

PERCENTILEX.INC(VALUES('Table'), [Measure], 0.9)

In this case, the measure returns the same value for every row because it doesn't respond to the row context created by VALUES(). This leads to incorrect percentile results.

The solution is to wrap the measure in CALCULATE(), ensuring it evaluates per row -

PERCENTILEX.INC(
   VALUES('Table'[Column]),
   CALCULATE([Measure]),
   0.9
)

This approach guarantees the measure recalculates for each row, delivering accurate results.

Re: STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently?

v-sshirivolu — Mon, 14 Jul 2025 04:06:37 GMT

Hi MarcoMazzocco ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Re: STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently?

v-sshirivolu — Mon, 21 Jul 2025 04:35:29 GMT

Hi MarcoMazzocco ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

Re: STDEVX and PERCENTILEX.INC ; aside form the math, do they operate differently?

v-sshirivolu — Thu, 24 Jul 2025 04:27:07 GMT

Hi MarcoMazzocco ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.