Help needed - Dynamic calculate Measure value based on Slicer Selection

[rashel2002]

in continue to my previous post (reference), i have these two tables:

and they are both connected by WW.

then i created this tablet that sum the total hours of every ww depends on the slicer choice (as you can see the slicer is on the priority).-

now, what i want to get is another column that will calculate the total hours depends on slicer selection (in this case - 14).

here is what i would like to get-

i know i need to create a measure that will calculate it because i want it to change according to the slicer selection, but i just don't know how to do it.

can someone please help me with it?

[TomMartens · Accepted solution]

Hey,

this will calculate the Total No. of hours:

Total No. of Hours = 
CALCULATE(
    SUM(Table1[No. of hours])
    ,ALLSELECTED(Table1)
)

Here is a little screenshot:

I already added this measure to the pbix file that I used for my answer in your reference post.

Hopefully this is what you are looking for

Regards

Tom