Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

sumx row and measur

In the simplified example in Excel, each location has an associated importance according to importance and compliance between 0 and 1.
Compliance is at the row level, but the importance is weighted according to filters that should always add 100%, therefore it is as a measure.
When trying to make the sum-product (sumx) you should not deliver a number greater than 1 and if you are doing it.

When trying to do the same in Excel, the necessary measure is the sum of the sumx, that is 99.44%

Need Help
Tutorial Requests
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You may change your Sumx measure like DAX below.

     

    Sumx=
VAR d= [ your original Sumx measure]
VAR _table =SUMMARIZE ( Table1, Table1[PDO], "_Value", d )
RETURN
IF ( HASONEVALUE ( Table1[PDO]), d, SUMX ( _table, [_Value] ) )

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    You may change your Sumx measure like DAX below.

     

    Sumx=
VAR d= [ your original Sumx measure]
VAR _table =SUMMARIZE ( Table1, Table1[PDO], "_Value", d )
RETURN
IF ( HASONEVALUE ( Table1[PDO]), d, SUMX ( _table, [_Value] ) )

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.