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

sjoerdvn's avatar
sjoerdvn
Icon for Solution Sage rankSolution Sage
2 years ago

I think you want to use a measure like this (note that you'll have to adapt to the proper table and column names, as these are not entirely clear from your information):

# tenants affected =CALCULATE(SUM(Stock[Members Affected]), CROSSFILTER(Stock[UPRN],RepairsFact[UPRN], Both))