Forum Discussion
how to add formula from visual matrix
- 3 years ago
Hi, PTSS
I restored some data and hope it matches your situation.
Sample data:
Measure = VAR _N1 =SUM ( 'Table'[Amount] ) VAR _N2 = CALCULATE (SUM ( 'Table'[Amount] ), FILTER (ALL ( 'Table' ), [Account] = "Factor Slippery" && [Date] = SELECTEDVALUE ( 'Table'[Date] ))) VAR _N3 = CALCULATE (SUM ( 'Table'[Amount] ), FILTER (ALL ( 'Table' ), [Account] = "Total Hujan" && [Date] = SELECTEDVALUE ( 'Table'[Date] ))) RETURN IF ( _N1 = BLANK (), _N2 * _N3, _N1 )Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, PTSS
I restored some data and hope it matches your situation.
Sample data:
Measure =
VAR _N1 =SUM ( 'Table'[Amount] )
VAR _N2 =
CALCULATE (SUM ( 'Table'[Amount] ),
FILTER (ALL ( 'Table' ),
[Account] = "Factor Slippery"
&& [Date] = SELECTEDVALUE ( 'Table'[Date] )))
VAR _N3 =
CALCULATE (SUM ( 'Table'[Amount] ),
FILTER (ALL ( 'Table' ),
[Account] = "Total Hujan"
&& [Date] = SELECTEDVALUE ( 'Table'[Date] )))
RETURN
IF ( _N1 = BLANK (), _N2 * _N3, _N1 )
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- PTSS3 years agoFrequent Visitor
amazing solution...
but can you help me again, how do you do it if the capex account value is not the same as slippery because the capex value is also 0.
and I want to add a formula in capex from slippery/100
thankyou