Sum totals in matrix that is based on a division measure

[Anonymous]

Hi Community, 

I have a problem, where I have a matrix. Based on these two tables (row and column), i will like to know, where a values from another tabels appears i both tabels, by written binary values. I got the "1" by divided the number with itself, and then get the number instead of the original value. 

So fx the with the values focused in the cicles, i will like it to write "2" instead of the division measure

I have try with if statements with the measure that returns the "1", but it does not show anything (i will like it to write both 1 and 0 so i mayby could get the total sum in the grandtotals) 

Really hope someone can help! 

[Tanushree_Kapse]

Hi @Anonymous ,

To get the correct grand total, use the below DAX:
Measure= SUMX(VALUES([Column_for_which_aggregating]), Overbooked demand2)

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks.

[Anonymous]

Thank you for the response!

I have try to write it, where "column_for_which_aggregating" is the tabel that i have create the measure that write "1" and then my if-funktion. But i think it is ignoring the if-funktion, because it just summerize the numbers i whink. So i will just like it to wirte 1 if there is a demand on the person or 0 if there is not, and then summerzie in the grand total, if one colum write "1" more than one time (fx two "1" it should write 2 in the grand total)

hope that make sense, I try to write your expression like this: 

And just to be clear, my other expression is written like this: 

 =