Total scope per project

[Zakaria_1980]

dears,

i've a table like this below:

based on the above data, i'd like to show me in my PBI report the following:

if I select project 1, total scope will be 78

if I select project 2, Total scope will be 100

if i select project 1 & 2, total scope will be 78+100

if I select all projects, it will be the sum of non dupplicated scopes

Thanks for your urgent support.

br,