Ranking measure works is not working on matrix filter criteria. Wrong output

[Chris_23]

Hi,

I have a measure that classifies the three projects with the highest score:

Spoiler

 Top3 = if(ISFILTERED(SlicerAAA[Info])=false(), "Top3",if(Calculate(Value(RANKX(ALLSELECTED(Submission[Project]), [Score])), ALLEXCEPT(Submission,Submission[Project]),ALLSELECTED(Submission[Date]) , ALLSELECTED(submission[Competition]))<=3, "Top3", "X"))

Spoiler

 Score = iferror(calculate(values(Submission[TestW]), ALLSELECTED(Submission[Filter])),0.01)*-1

In the column of the matrix the measure also works as desired. But now I want to attach the values to a SlicerAAA, which can be used to filter on the best three projects:

But if I set Top3 contains Top in the filter criteria of the matrix then I get an empty matrix. Unless I extend the date range over the whole period. In this case it shows me only the Top3 projects. So in the filter area for the visual, the selected date range is not taken into account, although it is correctly displayed in the matrix.

Any ideas what I need to adjust?

Kind regards

Chris

[amitchandak]

@Chris_23 , refer if this can help

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Chris_23]

Hi @amitchandak ,

thank you for your answer. I have now tried a few more approaches, but do not get the desired result.

sample pbix: https://1drv.ms/u/s!AsLM3f2rQCP34xz66vVhqHp5pDA5?e=udXGuN

I think the problem is that I calculate the Measure Value or Sum_No_1 over all projects, but not the filtered date range.

In principle, I would like to have a ranking only over the projects in the selected time window. Nov22: 1-27
Accordingly, only these projects would be shown in the matrix.

Maybe you see where the problem is.
I would be very grateful.

Kind regards
Chris