Help needed! It is a very simple task that i need to achieve but my formula does not work, for unknown reasons.
I have a number of locations and need to filter for the top 10 locations with the most injuries but only for locations with more than a certain amount of actual worked hours (e.g. 30'000).
My approach is to first filter the LOCATION Dim Table with FILTER() and then do the RANKX by Injury.
Here's my Formula so far:
FILTER(ALL(DM_VW_LOCATION);[Actual Worked Hours]>=30000);
CALCULATE([Total Injuries Rate];ALLEXCEPT(DM_VW_LOCATION;DM_VW_LOCATION[SiteCode]));;DESC;Dense)
Unfortunately the Measure still ranks locations below the 30'000 worked hours and provides very strange results:
There's no filter on that Matrix visualization yet, but my goal is to filter for Rank<=10 so that it only shows the top 10.
@Anonymous , for Rank refer these
For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures // check category and sub category rank herehttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finalehttps://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
Hi @amitchandak Thanks for the link. I've gone through it but still don't know where things are going south. The filtering for the subset of locations does not seem to work.
did you get the solution?
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!