Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

Count based on the Sum of a Variance at different levels of a hierarchy

I am making a dashboard that analyzes the difference between actuals and a plan for four different salients.  There are three different levels to the hierarchy: Level 1 (highest), Level 2(mid), and Level 3(lowest).  At each level you can analyze the variance, however as you move up the hierarcy the variance for all the lower levels are summed to create the variance at that level.


I am looking for assistnace in writing a Dax formula, or formual(s), so that I can count the number of elements at each level that are on plan (Variance = 0), behind plan (Variance <0, and ahead of plan (Variance >0). 


Any help would be greatly appreicated!






Hi @calmeida734,


Could you post your table structures with some sample/mock data and your expected result, so that we can better assist on this issue? Smiley Happy



Super User
Super User

Hey, can you please prepare sampledata and make this data available as a pbix file by providing a link to the file on onedrive or dropbox.



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors