Forum Discussion

Amzadkhan's avatar
Amzadkhan
Frequent Visitor
1 year ago

Adding Additional Column in the Matrix Table for % Completion

I have created two seperate Matrix tables for %Completion because I wanted to drill through to the isssues as in the screenshot #1.  Drill through was possible as I was able to use the Column from the table.

 

But coming to %Completion is a measure which is Divided by Value "Approved" from the column used in the first table, which is still not present due to no data, but here the problem is I wanted to comibine these two Matrix tables into one.  I tried that it is possible by using the measures, but by using measures drill through option is not possible it is always showing the total count.  


Please let me know if there is any way where I can add the %Completion Column in the Table #1 with other columns No Run, In Progress, Approved etc.  %Completion would be Division of Approved / Total and at the same time ability to drill through the specifc issues in each cell.

Need Help
Tips and Tricks

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    1 year ago

    Amzadkhan , Try using below steps

     

    Go to your data table in Power BI.
    Create a new calculated column using DAX (Data Analysis Expressions). The formula will be something like:
    %Completion = DIVIDE([Approved], [Total])


    This will create a column that calculates the percentage completion for each row in your data.
    Add the Calculated Column to Your Matrix Table:

    Go to your matrix table visualization.
    Add the new %Completion column to the Values section of the matrix.
    Ensure Drill Through Capability:

    Make sure that the fields you want to use for drill through are included in the matrix table.
    Configure the drill through settings to use the appropriate fields.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thank you bhanu_gautam 

    Hi, Amzadkhan 

    Have you solved the current problem? If you have already solved the current problem, you can share your answer here and mark the helpful reply as a solution.
    If you haven't resolved your current issue? Can you further describe the output you are looking forward to, or provide an example of a PBIX file that does not contain sensitive information?

     

    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.