Percentile formula not respecting the slicers

[Jhonatta_Bernar]

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

[Anonymous]

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.

[rajendraongole1]

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!!

[Jhonatta_Bernar]

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

look.

[rajendraongole1]

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!!