Showing results for 
Search instead for 
Did you mean: 
New Member

Power BI and DAX expressions

Hi Experts,

I am very new to the DAX expressions and Power BI. Please give me some insights for the below requirement.


i need to create a measure, which need to averaged as you scroll up the hierarchy and if i click into next level it has to show sum for the same measure.


Basically i need to do both with same measure combination of Average and Sum when you scroll up it has do Average and when you scroll down it has to do sum.


Thanks in advance for your time & help.



Memorable Member
Memorable Member

Re: Power BI and DAX expressions

If you seek an Avg or Sum of an entire column - then this can be implemented at the visual design level as an embedded feature - create a table visual and you can experiment.


There may be a need to do it via a Dax measurement depending on what you seek and a small sample of the structure of your data will help the community provide guidance.


You have me a little perplexed on the idea of the direction of scrolling changing between avg or sum - - not sure that is a viable idea.
Community Support
Community Support

Re: Power BI and DAX expressions

Hi @BIuser1234,


Power bi not support to change the the calculate result based on scrolling bar. In my opinion, I'd like to suggest you create a measure to shows the average and sum at same time.



AVG/SUM = ROUND(AVERAGE('Table'[Value]),2)&"/"&SUM('Table'[Value]) 





Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (895)