Forum Discussion

rashel2002's avatar
rashel2002
Helper II
8 years ago
Solved

Help needed - Dynamic calculate Measure value based on Slicer Selection

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 t...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    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

     

     

TomMartens's avatar
TomMartens
Super User
8 years ago

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