Hi, I have a problem. I like to show the To 3 Open AR Overdue Positions within a matrix visual. I have the two Filters Customers (Kunde) and Fälligkeiten (Overdues)
If I cluster them in the matrix in a way like the first chart, I will get the top 3 and the right information concerning the overdues.
If I cluster the overdues as colums, my formula will give the 3 Top overdues in each category (A nicht fällig etc.)
But that is not what I want. I want that my formula only gives my the top 3 Overdues and then shows their category. So it would be the top three overdues of the customers regardless of the sub category Fälligkeiten.
Has anybody an idea what could help?
Best Regards Mike
Solved! Go to Solution.
Hi @MichaelSievers ,
Not sure about your issue.
I have built a data sample:
Then simply used the following formula :
Offene Posten = SUM('Table'[Value])
Top N OP_II = calculate ([Offene Posten],KEEPFILTERS(TOPN(3,ALLSELECTED('Table'),[Offene Posten])))
The final output in my side is shown below, seemed to work.
Please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data to help us clarify your scenario.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@MichaelSievers , What is expected output, please share in table format
Top N OP_II = calculate ([Offene Posten],TOPN(3,ALLSELECTED('Pseudo
KNA1 Table'),[Offene Posten]), value('Pseudo
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!