Forum Discussion
Solved
Calculate Measure using a relationship
Hi Community, I need some help solving the following question. I have a table containing all contracts a team is responsible for and the % of Sales their commission is calculated on. T...
You are going to have to modify the measure to take Team totals into account. It is basically the same process as grand total lines. Check out my Matrix Measure Triple Threat Rock and Roll.
Hi DamienDhaene,
You can also take a look at following blog to know how to calculate dax formula on hierarchy total level:
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng