Forum Discussion

Grimfandango227's avatar
Grimfandango227
Frequent Visitor
2 years ago
Solved

Non-Summerized Percentages in Matrix Visual

Hello!   I am having trouble simply showing the Percentage of Overtime hours in the Total hours worked. Every time I add to the Matrix it Summarizes the totals and it is incorrect. Screenshots belo...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Grimfandango227 ,

     

    First of all, thanks Greg_Deckler  for the quick reply.

    According to your description, you can try creating a measure and then placing the measure on the matrix.

    OT % = SUM('Table'[OT Percentage])

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Grimfandango227 ,

 

First of all, thanks Greg_Deckler  for the quick reply.

According to your description, you can try creating a measure and then placing the measure on the matrix.

OT % = SUM('Table'[OT Percentage])

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.