Forum Discussion

carly_030's avatar
carly_030
Regular Visitor
2 years ago
Solved

Row % total

I have matrix table as below where the % is worked out from measure/days available. 

How can I get the total (in bold) to be the % of that total i.e. 67/441 - 15% and not 319%?

Thanks in advance 🙂

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    hi, carly_030 

    I'm happy to answer your questions. Here I offer my solution，We can use the following dax formula:

    Column = CALCULATE(DIVIDE(SUM(Tabelle1[meausre]),SUM('Tabelle1'[day])))

    Then change the format of the calculated column to percentage:

    The results are as follows:

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    hi, carly_030 

    I'm happy to answer your questions. Here I offer my solution，We can use the following dax formula:

    Column = CALCULATE(DIVIDE(SUM(Tabelle1[meausre]),SUM('Tabelle1'[day])))

    Then change the format of the calculated column to percentage:

    The results are as follows:

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

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