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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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