Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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]))
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]))
1 What filter context do you have, including row/column of the matrix, slicer, filter pane?
2) How is [Total expense] defined?
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])
User | Count |
---|---|
69 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |