Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum of Distinct Values

Hello, I am trying to calculate sum of keys for the following table of data   Application Data Subject Table  Number of Keys App1 Account A 1000 App1 Customer B 500 App1 Asset...
Need Help
Tutorial Requests
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    Try this measure:

     

    KeyCount =
CALCULATE (
    SUMX (
        SUMMARIZE (
            Keys,
            Keys[Application],
            Keys[Data Subject],
            "NumKeys", MAX ( Keys[Number of Keys] )
        ),
        [NumKeys]
    )
)

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
7 years ago

Try this measure:

 

KeyCount =
CALCULATE (
    SUMX (
        SUMMARIZE (
            Keys,
            Keys[Application],
            Keys[Data Subject],
            "NumKeys", MAX ( Keys[Number of Keys] )
        ),
        [NumKeys]
    )
)

Hope this helps

David