cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rashel2002 Regular Visitor
Regular Visitor

Help needed - Dynamic calculate Measure value based on Slicer Selection

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

8.PNG9.PNG

 

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).-

11.PNG

 

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-

12.PNG

 

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Help needed - Dynamic calculate Measure value based on Slicer Selection

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:

image.png

 

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

 

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
1 REPLY 1
Super User
Super User

Re: Help needed - Dynamic calculate Measure value based on Slicer Selection

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:

image.png

 

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

 

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!