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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

How to avoid summing of values.

I have below data. The below data is correct when i dont filter particular client (2nd column), but when i filter the 2nd row client, the fifth column Clientbase sums up values (2nd screen shot). Let me know how to avoid this. 

 

Kiranbc_0-1671603599779.png

I filtered on 2nd row it should show clientbase hours as 471.04 but it is showing 1324.0. 

Kiranbc_1-1671603734390.png

 

CLientbase is sum of Measure which is sum of hours. 

BIllable hours is also measure (sum of billed hours).

 

1 REPLY 1
FreemanZ
Super User
Super User

hi @Anonymous 

can you paste the code of the mentioned measures?

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.