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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
OptimaOffice
Regular Visitor

How to use a SUMX measure in the context of the slicer filter

Hi,

I am using a SUMX measure to calculate the effective bill rate of a dataset:

Eff bill rate = CALCULATE(SUMX('Client hours','Client hours'[Input]*'Client hours'[Bill Rate]))/SUM('Client hours'[Input])
 
The dataset contains data for several employees over 4 months. I would like the effective bill rate to be calculated for the selected employee and for the selected period. However the effective bill rate always returns the same amount and does not change with the slicer filters. How can i fix this? Do I need to instead calculate this in power query? I am not sure how I can attach a sample of the file...
 
Thank you,
Dana
2 REPLIES 2
tamerj1
Super User
Super User

Hi @OptimaOffice 

you can share via download link. Screenshots also greatly help 

Hi, Here is the link to the test file. I am guessing it's something pretty basic that I am missing: https://drive.google.com/file/d/1T7dKBNEk7m_kIIw2l0FYFCb3psc9ZYxd/view?usp=share_link Thank you, Dana

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.