topic Re: Percentile formula not respecting the slicers in DAX Commands and Tips

Percentile formula not respecting the slicers

Jhonatta_Bernar — Wed, 12 Jun 2024 17:05:25 GMT

Hello everyone, I have here a DAX to return me a quartile for the measure [Test Net Revenue %], it's returning me the right quartile for the right Time period slicer, but for the BUs slicer os not repecting the slicer. How can I return the quartiles respecting the filters?

Thanks

Re: Percentile formula not respecting the slicers

rajendraongole1 — Wed, 12 Jun 2024 17:44:28 GMT

Hi Jhonatta_Bernar - Create a below measure with All selected() function , for quartile respects all slicers, including the Business Unit (BU) slicer.

Teste Quartile =
CALCULATE (
PERCENTILEX.INC(
ALLSELECTED(dCountries),
[Test Net Revenue %],
0.75
)
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Re: Percentile formula not respecting the slicers

Jhonatta_Bernar — Wed, 12 Jun 2024 17:57:37 GMT

It didn't work, it just repeats the [Test Net Revenue %] that I already have.

look.

Re: Percentile formula not respecting the slicers

Anonymous — Thu, 13 Jun 2024 01:35:19 GMT

Hi Jhonatta_Bernar

Please try the following Dax:

Teste Quartile = CALCULATE( PERCENTILE.INC('dCountries'[Test Net Revenue %], 0.75), ALLSELECTED('dCountries','dCountries'[BUs]) )

If your problem is still not solved, please provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

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

Re: Percentile formula not respecting the slicers

rajendraongole1 — Thu, 13 Jun 2024 05:22:12 GMT

Hi Jhonatta_Bernar - Can you please share the same with sample data and what are the filters that you are using list.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!