Forum Discussion
how to add formula from visual matrix
currently I have a data concept like this that I insert in the power bi matrix
Rows
Project
Account
Column
Date
Value
AMount
i want to change the amount from the rain/day account to a formula
fill in the formula Factor Slippery*Total Hujan
what kind of formula should I use, please help
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.
3 Replies
v-zhangtiCommunity Support
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.
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
