Help with baseline top 5%

Mikes128 — Fri, 05 Jul 2024 14:38:08 GMT

I have the following measures: top 5 values for the difference between current year and baseline and difference between current year. The issue I am having is that the top 5 can be +100% due to negative values in the difference. Is there a way that I can filter the negative values out of the difference measure?

Re: Help with baseline top 5%

Sahir_Maharaj — Sun, 07 Jul 2024 13:23:08 GMT

Hello Mikes128,

Can you please try the following:

1. Calculate the difference between the current year and the baseline

DifferenceMeasure = [CurrentYearValue] - [BaselineValue]

2. Filter out negative values

FilteredDifferenceMeasure = IF([DifferenceMeasure] > 0, [DifferenceMeasure], BLANK())

3. Rank the top 5 values of the filtered difference

RankFilteredDifference = RANKX( ALL('Table'), [FilteredDifferenceMeasure], , DESC, DENSE )

4. Show the top 5 values of the filtered difference

Top5FilteredDifference = IF( [RankFilteredDifference] <= 5, [FilteredDifferenceMeasure], BLANK() )

Hope this helps.

topic Re: Help with baseline top 5% in DAX Commands and Tips

Help with baseline top 5%

Re: Help with baseline top 5%