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 ,
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