Hi guys!
I need a little help about DAX formula to calculate comission for some items.
2 tables:
Commission Table
<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
<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?
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>
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?