Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rashel2002
Helper II
Helper II

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
TomMartens
Super User
Super User

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

 

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

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

 

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.