Forum Discussion

apvu2's avatar
apvu2
Icon for Helper I rankHelper I
4 years ago
Solved

Divide when slicer is slected

So I have two data sets one is my master table, table X, which contains a client name and a daily revenue.  then have another table, table Y that contains salesmen who worked on this client. I have a...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    apvu2 , Try like

     

    Divide(sum(Table1[Daily revenue]), calculate(sum(Table1[Daily revenue]), all(table2[sales person]) ) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

apvu2 , Try like

 

Divide(sum(Table1[Daily revenue]), calculate(sum(Table1[Daily revenue]), all(table2[sales person]) ) )

apvu2's avatar
apvu2
Icon for Helper I rankHelper I
4 years ago

It works, for the totals, but it does not update the numbers for the total revenue inside the matrix for the clients.