Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

DAX SUM query

Hi Community  I have the following model in desktop Here is an example of the facts table.    My Stock dimension table connects to the fact table using the UPRN field.   The Stock dim...
Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  cottrera ,

    Thanks for your feedback. If you still want to get it, you can create antoher new measure as below and replace the original measure [Members Affected] on the visual.

    Measure = SUMX ( VALUES ( 'DIM_Stock'[UPRN] ), [Members Affected] )

    Best Regards

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi v-yiruan-msft & sjoerdvn by company has now decided they no longer need the insight that I was working on . Therefore the measure I required is no required. Thank you for your help

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  cottrera ,

    Thanks for your feedback. If you still want to get it, you can create antoher new measure as below and replace the original measure [Members Affected] on the visual.

    Measure = SUMX ( VALUES ( 'DIM_Stock'[UPRN] ), [Members Affected] )

    Best Regards