How to calculate percentage for a particular column with different groups

[manjeshjk]

Hi All,

How to calculate percentage for a particular column with different groups. I am not able to visualize how to achieve this.

sample data

---------------

Date	Curre	Exchange Rate	Amount	Age	Customer
1-Jan	USD	85	6000	> 15 Days	A
2-Jan	EUR	88	5600	> 15 Days	A
3-Jan	EUR	88.2	5555	> 15 Days	D
4-Jan	EUR	88.2	5433	< 15 Days	F
5-Jan	USD	84.34	4322	< 15 Days	G
6-Jan	USD	86.3	45556	< 15 Days	G
6-Jan	USD	87.2	1000	> 15 Days	G
6-Jan	USD	87.2	1000	> 15 Days	F

Expected Output Data

--------------

Age
< 15 Days	< Days%	> 15 Days	> 15 Days%	Total
5433	84%	1000	16%	6433

I need this calculated data in the Matrix Grid 

Appreciate your feedback/comments/suggestions.

[v-yueyunzh-msft · Accepted solution]

Hi , @manjeshjk 

According to your description, you want to get the % of the row in the Matrix visual .

Here are the steps you can refer to :

We can create a measure like this:

Measure = DIVIDE(SUM('Table'[Amount]) , CALCULATE( SUM('Table'[Amount]) , ALLSELECTED('Table'[Age])))

Then we can put it on the visual and we can meet your need:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[manjeshjk]

Appreciate the support, works as expected.