Forum Discussion

Jhonatta_Bernar's avatar
Jhonatta_Bernar
Regular Visitor
2 years ago

Percentile formula not respecting the slicers

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 ...
Need Help
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

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's avatar
    Jhonatta_Bernar
    Regular Visitor
    2 years ago

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

    look.

     

    • rajendraongole1's avatar
      rajendraongole1
      Icon for Super User rankSuper User
      2 years ago

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