Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Below I have a picture of a Matrix of an Incomestatement : For Budget it is totaling correctly; however, I want expenses to be positive. In actuals I flipped expenses to be positive; however, now the grand total is off. How can I get it to where I have positive rev - positive exp = total?
Solved! Go to Solution.
@Anonymous,
Try this solution:
1. Create calculated column:
Adjusted Actuals = IF ( FactTable[Main Type] = "Expenses", [Actuals] * -1, [Actuals] )
2. Create measure:
Actuals =
IF (
HASONEVALUE ( FactTable[Main Type] ),
SUM ( FactTable[Actuals] ),
SUM ( FactTable[Adjusted Actuals] )
)
Proud to be a Super User!
@Anonymous,
Try this solution:
1. Create calculated column:
Adjusted Actuals = IF ( FactTable[Main Type] = "Expenses", [Actuals] * -1, [Actuals] )
2. Create measure:
Actuals =
IF (
HASONEVALUE ( FactTable[Main Type] ),
SUM ( FactTable[Actuals] ),
SUM ( FactTable[Adjusted Actuals] )
)
Proud to be a Super User!
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |