Divide by Filtered Measure

[Jungbin]

Hi there!

I made two measures and one calculated column:

• Closed Amount Team = SUMX(FILTER('All Leads','All Leads'[Close Date].[Date]>DATE(2022212,31)&&'All Leads'[Stage]="Closed"),'All Leads'[Total Amount])+0
• Closed Amount Country = CALCULATE(SUM('Orders'[Closed Amount]),'Order'[Category]="Closed")
• Closed Amount = IF('Order'[Category]="Closed",'Order'[A]+'Order'[B]+'Order'[C])

, and below I described what I want to make and what I'm currently struggling with.

Can anyone help me on this?

What I want

Team	Closed Amount Team	Closed Amount Country	Closed Amount %
Sales	$5,000,000	$10,000,000	50%
Marketing	$3,000,000	$10,000,000	30%
Service	$800,000	$10,000,000	8%
Others	$1,200,000	$10,000,000	12%
Total	$10,000,000	$10,000,000	100%

What I'm currently facing

Team	Closed Amount Team	Closed Amount Country	Closed Amount %
Sales	$5,000,000	$5,000,000	100%
Marketing	$3,000,000	$3,000,000	100%
Service	$800,000	$800,000	100%
Others	$1,200,000	$1,200,000	100%
Total	$10,000,000	$10,000,000	100%

[Anonymous]

Hi @Jungbin ,

Please try like:

Closed Amount % = SUMX(SUMMARIZE('Table','Table'[Team],"C_A_T",[Closed Amount Country],"C_A_C",[Closed Amount Country]), DIVIDE([C_A_T],[C_A_C])) 

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

Hi @Jungbin ,

 the "Closed Amount %" for each team by dividing the "Closed Amount Team" by the "Closed Amount Country" and then display these percentages in a table.

Closed Amount % =
DIVIDE(
[Closed Amount Team],
[Closed Amount Country],
0
)

[Jungbin]

Hi @Anonymous, thanks for your comment.

However, the "Closed Amount %" in my table is already a separate Measure. 

I put that measure in PBI matrix, and it shows what I'm currently looking at.

[selected_]

The user vs_7 are spammer and using ChatGPT and copy and paste all answer from there. He's spamming all over this forum.