Forum Discussion

venkatasuresh_g's avatar
venkatasuresh_g
Icon for Helper IV rankHelper IV
2 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

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!