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 thank you for responding so quickly.

 

Members and Tenants affected are the same (appologies) The members figures is a measure that points at  DIM_Stock table 

Members Affected = SUM(Stock[Members Affected])
 
The UPRN is from theDIM_Stock table 

 

thank you