Forum Discussion
Matrix Visual wrong column subtotals for percentages
Hi
I amd caclulating percentage from attendance table, using simple formula "Compliance% = [Total_attendance]/[#workdays]" , when I use this in a table it works fine , when I use the same in matrix visual I get the correct % when I expand the category to see each rown , when I drill up to department level all % shows as 100%. can some one please guide me how to fix the measure
Drill down Drill up mode
Thanks
Suresh
Hi venkatasuresh_g ,
I want to acknowledge valuable input provided by tharunkumarRTK . The ISFILTERED function and the ISINSCOPE function are very helpful for the handling of hierarchical structures. Did the blog link provided by tharunkumarRTK help you with your problem? If solved, please mark the helpful answer as a solution this will help more people, if not please point it out.
Best Regards,
Neeko Tang
2 Replies
You need to correct the DAX formula and handle the matrix hirerachies properly. Please follow this article
https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/The above article should solve your problem if not then please the pbix file with sample data and expected result.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Hi venkatasuresh_g ,
I want to acknowledge valuable input provided by tharunkumarRTK . The ISFILTERED function and the ISINSCOPE function are very helpful for the handling of hierarchical structures. Did the blog link provided by tharunkumarRTK help you with your problem? If solved, please mark the helpful answer as a solution this will help more people, if not please point it out.
Best Regards,
Neeko Tang
