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 column is correct, but row isnt correct, how can i solve? example first row, 30.45 + 0.01 = 30.46 not 91.37

 

  • 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]))

3 Replies

  • 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]))
  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    1 What filter context do you have, including row/column of the matrix, slicer, filter pane?

    2) How is [Total expense] defined?

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

      only filter is date i use date slicer,

      Total expense = IF([Item Count per product]>1,[Price] * [Rev per Item] * [Item Count per product],[Price] * [Rev per Item])