Adding Additional Column in the Matrix Table for % Completion

[Amzadkhan]

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.

[Anonymous]

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.

[bhanu_gautam]

@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.