To remove a filter in a visual and re-add a filter in DAX

[charonT]

Hello, I have a table containing extensive provider data, and the Scatter chart currently applies a filter 'test'[Provider]="B" to display data specific to this provider. However, I aim to calculate a percentile for this provider among all providers. The criteria for inclusion in the ranking calculation are as follows: If [provider]="B" and sum([denominator]) is greater than or equal to 2, then 'B' will be considered. Simultaneously, for other providers, if [provider]<>"B" and [denominator] is greater than or equal to 3, those providers will be included in the calculation.

I have implemented DAX calculations for YoY change and percentile. The Scatter chart is configured with the x-axis representing YoY change and the y-axis representing the percentile. However, the visualization does not align with my expectations.

The following screenshoots are the examples of the trial data. This is the pbix file of it,

https://drive.google.com/file/d/1ilhuv5fh2hDdrcH3uLI4V2wkeYb5hhBg/view?usp=drive_link

In my real dataset, when the denominator does not meet the threshold (i.e., 3 in the attached example) for other providers, the data points are placed at the top of the chart with a ranking of 1/1. But the rest of it is fine.

Thank you in advance.

[AmiraBedh]

I am assuming the following :

Adjusted Percentile = 
VAR CurrentProvider = MAX(test[Provider])  // Get the current provider
VAR SumDenominator = SUM(test[denominator])  // Sum of denominator for the current context
RETURN
IF(
   (CurrentProvider = "B" && SumDenominator >= 2) ||
   (CurrentProvider <> "B" && SumDenominator >= 3),
   PERCENTILEX.INC(
       FILTER(
           ALL(test),
           (test[Provider] = "B" && test[denominator] >= 2) ||
           (test[Provider] <> "B" && test[denominator] >= 3)
       ),
       [YourMeasure], // Replace with the measure you're calculating the percentile for
       0.5
   ),
   BLANK()
)

[charonT]

Hi Thank you for your reply. It seems this is not working, in my personal data, this DAX did not return the percentile of each class among the providers, instead, it returns an overall percentile, regardless of the class