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]
)

b_koe's avatar
b_koe
New Member
1 year ago

Unfortunately, still having the same issue. The outcome is identical to my posted measure above. Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi b_koe ,

    I have changed the measure please check and try with the below

    Default PF = CALCULATE(
    AVERAGE('DPS 20240816'[DefaultProductivity2]),
    ALL('DPS 20240816')
    )

    • b_koe's avatar
      b_koe
      New Member
      1 year ago

      It has changed slightly but still the incorrect outcome.