Forum Discussion
Divide by Filtered Measure
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...
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
)
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_Helper IV
The user vs_7 are spammer and using ChatGPT and copy and paste all answer from there. He's spamming all over this forum.