Forum Discussion

avi081265's avatar
avi081265
Icon for Helper III rankHelper III
5 years ago

How to add one calculated column matrix column

Hello    Please see below table. I want to add one calculated coumn as %NA after 06-NA  column. In this %NA column I want use formula as %NA = 06-NA / Total. I tried following formula from a...
Need Help
avi081265's avatar
avi081265
Icon for Helper III rankHelper III
5 years ago

Hello All,

 

Is it possible to calculate percentage for each status and each row? See below screen chart and red color box. How can we implement this. First Image  is field mapping and second image waht I am looking for 

 

 

How Can I display % cerntage for each status for each row?

 

Thanks in advance.

Avian

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi avi081265 ,

     

    I created some sample data as follows

     

    If you want to display % cerntage for each status for each row? Just put the meaesure you created into values.

    Measure = DIVIDE(MAX('Table'[Value]),CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[User])))

     

    If you only want to display percentages in one column, you need to pivot in Power Query. Select the Category column and click Pivot Column, Values column to select value, and select Don't Aggerate in the advanced option.

     

    Create the NA% measure

    NA% = DIVIDE(SUM('Table (2)'[06-NA]),SUM('Table (2)'[01-PLAN])+SUM('Table (2)'[02-DO])+SUM('Table (2)'[06-NA]))

     

    You can check more details from here.

     

     

    Best Regards,

    Stephen Tao

     

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

    • avi081265's avatar
      avi081265
      Icon for Helper III rankHelper III
      5 years ago

      Hello Stephen,

       

      I shared link of sample file with you as private message. Please review.

       

      Avian