Power BI and DAX expressions

[BIuser1234]

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.

BIUser

[v-shex-msft]

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.

Measure:

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

Regards,

Xiaoxin Sheng

[CahabaData]

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.