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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
mihail_p
New Member

The measure at the top level of the hierarchy is empty, although children have values

I have a measure that should count acts and payments, and if there are more acts than payments, then it should display a value, otherwise it is empty.
But when calculating this measure for a hierarchy, I see BLANK at the top level, although the children of the hierarchy have values.
How can I get at the top level of the hierarchy the sum of the values of the lower levels of the hierarchy?

 

Screenshoot - http://joxi.ru/L21zZndsR485ZA 

 

Measure without verification:

 

Measure =
var acts_91121 = CALCULATE(sum('test'[value]),'test'[type] = "act")
var bp_91121 = CALCULATE(sum('test'[value]),'test'[type] = "payment")
var itog_91121 = acts_91121-bp_91121
return itog_91121

 

 

Measure with verification:

 

Measure =
var acts_91121 = CALCULATE(sum('test'[value]),'test'[type] = "act")
var bp_91121 = CALCULATE(sum('test'[value]),'test'[type] = "payment")
var itog_91121 = if(acts_91121-bp_91121<0,blank(),acts_91121-bp_91121)
return itog_91121

 

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @mihail_p 

you do

SUMX (

summary table of your hierarchy,

[measure]
)

this will desply the aggregated values over all levels including the total. 

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

Hi @mihail_p 

you do

SUMX (

summary table of your hierarchy,

[measure]
)

this will desply the aggregated values over all levels including the total. 

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Users online (25)