Sum of two columns (each in a different table) grouped by

[AFra]

Hi all, 

I have 3 tables : 

- an index table linked to two other tables (NOM_CODE)

- a table in which I count X (Count of CodeCADASTRE)

- a table in which I count Y (Count of N° SISP)

I would like a Total column that calculates for each line of NOM_CODE the sum of the two other columns.

For example for "2040 - En bords de soignes" I would have 1751. 

Any ideas? 

Thanks in advance! 

Ana 

[Thim · Accepted solution]

Try make a make a new meassure with 2 count formula looking something like this
Total Count = Count(CodeCADASTRE) + Count(N° SISP)

When you put this in with your matrix, Power BI should filter it by Nom Codes as well.

[AFra]

shame on me, of course it works. I thought it wouldn't take in account the "group by" NOM_CODE. 

Thanks a lot!