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 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?

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

     

     

1 Reply

  • 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