Power pivot - dax formula to calculate comission

[Osti2]

Hi guys!

I need a little help about DAX formula to calculate comission for some items.

2 tables:

Commission Table

ID	FAMILY	PRODUCT	COMISSION
1	100	*	10%
2	100	CAR	5%
3	200	*	6%
4	300	*	7%

<colgroup><col width="80" span="4" style="width:60pt"> </colgroup><tbody>
</tbody>

<colgroup><col width="80" span="4" style="width:60pt"></colgroup><tbody> </tbody>

<colgroup><col width="80" span="4" style="width:60pt"></colgroup><tbody>
</tbody>

FACT TABLE

ID	FAMILY	PRODUCT	Euros	COMISSION	Total Com
1	100	MOTO	100	10%	10
2	300	APPLE	200	7%	14
3	200	HOUSE	300	6%	18
4	100	CAR	400	5%	20

<colgroup><col width="80" span="6" style="width:60pt"> </colgroup><tbody>
</tbody>

Last two columns for FACT Table are calculated by DAX FORMULA

I need a formula with DAX that:

1.- Search if there's a comission (=FAMILY and =PRODUCT).
2.- If there's no comission, search for only one variable (=FAMILY and Product =*).

Do you know how to do it?