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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi cottrera ,

Thanks for reaching out to us about your problem. Base on my research, it seems that you want to get the count of 'tenant effected' and display it on the card visual. In order to make further troubleshooting and give you a solution shortly, could you please provide the following info? It would be very helpful to find the solution. Thank you.

  • Are the field [Members Affected] and 'tenant effected' the same?
  • Is the field[Members Affected] a measure or fact field in the table 'Stock'? If it is a measure, could you please provide the related formula?

        

  • What's the formula of [Tenants Affected]?
  • How did you set the following output? Is the field [UPRN] from stock dimension table or facts table?
    UPRN Tenants Affected
    18 1
    18 1
    26 3
    26 3
    26 3

Best Regards