Sum of value in Dimension Table, with count from fact table

[tanat_inc]

Hi Community, 

I have the data as diagram below :

I have tried to calculate commission for each Agent_name with :

I expected it to return 2000 for FB_Agent_1 commission

and 1500 for TW_Agent_1 commission

Have no success with sumx and values, please suggest how to do that without merge table with power query.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

Commission total measure: = 
SUMX('Fact', RELATED(Dim[Commission]))

[tanat_inc]

It's work.

Thanks a lot.