Forum Discussion

b_koe's avatar
b_koe
New Member
1 year ago

DAX Divide Measure producing same value for all categories when a filter is applied

Hello,    I have a column of data that is in decimal form and I need an average of it, I do not want it to sum so I have used the following measure.   Default PF = DIVIDE(SUM('DPS 20240816'[Defa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi b_koe ,

Try below measure

Default PF = AVERAGEX(
'DPS 20240816',
'DPS 20240816'[DefaultProductivity2]
)

suparnababu8's avatar
suparnababu8
Super User
1 year ago

Thanks for your reply Anonymous . Ideally it should works. b_koe  Make sure to have proper relationships.
If you need solution, pls post detailed question with out any sentive data.