Forum Discussion

Sania-F's avatar
Sania-F
Resolver I
11 months ago

VALUES function with HASONEVALUE and SUMX iterator function

sales commission iterator = SUMX(     VALUES('Sales Territory'[Region]),     CALCULATE(         [Revenue]         * IF(             VALUES('Sales Territory'[Country]) = "United States",      ...