Forum Discussion

gambleave's avatar
gambleave
Icon for Helper II rankHelper II
4 years ago

Iterating measure with SUMX

I cannot get a SUMX measure working for this scenario - would greatly appreciate advice:   I have a measure to count the number of distinct sales from a fact table: Distinct Sales = CALCULATE(DIST...
Need Help
Tutorial Requests
gambleave's avatar
gambleave
Icon for Helper II rankHelper II
4 years ago

Thanks very much for your help, yes it does seem to work as required 🙂 It seems that the Volume measure is written out here rather than just being referenced. I am wondering if the same approach would work to implement a SUMX for more complex measures (e.g. that nest measures referencing multiple tables in the model)?  Thank you.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

gambleave You're right, the Volume measure could be used in the measure I created, like this:

High Volume Employee Count = 
    SUMX(
        VALUES('InteractionHistory'[Employee Name]),
        [Volume]
    )