Divide within same column of a table

[jungminyu]

Hi all, I would like to put a percentage in between the "Aged" and "Total. 

Tried to add a quick measure to divide but did not work as it was in the same column of data. 

Seems I need to add a measure DAX function? Can anyone help me out with this please? 

The desired output would be something like this. It is simple in excel but cannot figure out on power bi bc it is within the same column. Please help me

[jungminyu]

Hi Jianpeng Li,

Thanks for your reply. I cannot add a division measure to get % and it seems to be because I added a customized conditional column to retrieve "Aged" or "not Aged "data like below. 

so if I add a division measure as this "Aged" column as a numerator, it does not turn to "sum of Aged" but turns to "countA Aged"...

Do you know how I can fix this? 

Thanks in advance!

[Anonymous]

Hi, @jungminyu 

Can you provide some dummy sample data that doesn't include your privacy?  If you add a measure, a measure column will be generated in both the aged and Total columns in the matrix, as shown below:

In this case, you only need to add a column between the Aged column and the total, which is currently achieved by customizing the matrix header. You can refer to the following articles and tutorials:

Creating a “custom” or “hybrid” matrix in PowerBI - Microsoft Fabric Community

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.