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
NavaneethaRaju
Helper IV
Helper IV

Measure is creating duplicates

Hi,
I created one measures, its return duplicates while i'm using columns in from another table.
And also its returning the wrong values.

CALCULATE(SUM('Procedure Fact'[C501B_QTY]),ALLEXCEPT('Tag Usage Fact','Tag Usage Fact'[TAG_ID]))


can you guys advice any measure to find sum value respective of particular column data.

NavaneethaRaju_0-1656397838681.png

 

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @NavaneethaRaju 

 

Measure:

Measure 1 = CALCULATE(SUM('Table'[QTY]),ALLEXCEPT('Table','Table'[ID]))
Measure 2 = CALCULATE(SUM('Table'[QTY]),ALL('Table'))
Measure 3 = CALCULATE(SUM('Table'[QTY]))

vzhangti_0-1656642151139.png

Which result is your desired outcome? If none of them is correct, please tell us the output result you expect.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @NavaneethaRaju 

 

Measure:

Measure 1 = CALCULATE(SUM('Table'[QTY]),ALLEXCEPT('Table','Table'[ID]))
Measure 2 = CALCULATE(SUM('Table'[QTY]),ALL('Table'))
Measure 3 = CALCULATE(SUM('Table'[QTY]))

vzhangti_0-1656642151139.png

Which result is your desired outcome? If none of them is correct, please tell us the output result you expect.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tamerj1
Super User
Super User

@NavaneethaRaju 

Please clarify the problem. Does this table explain the problem or show the expected result?

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.