Forum Discussion

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago
Solved

total not correct

hello everyone, i have a matrix table, and formula correct = IF(HASONEVALUE('Product Revenue'[Item]),[Total expense],SUMX(VALUES('Product Revenue'[Item]),[Total expense]))     the co...
  • eliasayyy's avatar
    eliasayyy
    3 years ago

    just created another measure,

    correct 1 = IF(HASONEVALUE('Product Revenue'[product]),[Total expense],SUMX(VALUES('Product Revenue'[product]),[Total expense]))

correct 2 = IF(HASONEVALUE('Product Revenue'[item]),[correct 1],SUMX(VALUES('Product Revenue'[Item]),[correct 1]))
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

just created another measure,

correct 1 = IF(HASONEVALUE('Product Revenue'[product]),[Total expense],SUMX(VALUES('Product Revenue'[product]),[Total expense]))

correct 2 = IF(HASONEVALUE('Product Revenue'[item]),[correct 1],SUMX(VALUES('Product Revenue'[Item]),[correct 1]))