Matrix Visual wrong column subtotals for percentages

[venkatasuresh_g]

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

[Anonymous · Accepted solution]

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

[tharunkumarRTK]

@venkatasuresh_g 

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!