Hi all,
I have a measure named Amount Excluded derived from measure named Flag.
The logic for Flag Measure is:
Flag =
IF (
SELECTEDVALUE(DimProduct[ProductName]) = "A",
"2",
IF(
[Original Amount]>0,
"0","1")
))
The logic for Amount Measure is:
SUMX(
SUMMARIZE(vw_DimProduct,vw_DimProduct[ProductName],"Amt Exclude",
IF([Identifier] = "1",[Original Amount],BLANK())),[Amt Exclude])
p/s: I am able to get total -7000 when I use SUMX.
I want to create another measure, named Adjusted Amount where the calculation is based on total Amount Excluded. Example of calculation is as follow:
Product | Original Amount | Flag | Amount Excluded | Adjusted Amount |
A | 1000 | 2 | | |
B | 0 | 1 | 0 | |
C | -5000 | 1 | -5000 | |
D | -2000 | 0 | -2000 | |
E | 3000 | 0 | | = (-7000/2)+3000 |
F | 1000 | 0 | | = (-7000/2)+1000 |
TOTAL | 9000 | | -7000 | |
But currrently, I cannot do that, it detect Amount Excluded as Blank instead of -7000. I think because it treat by line, in Row and F, Amount Excluded is Blank, that's why.
How do I ask it to take value -7000?
I checked other queries but none of it works on my case.
Looking forward to hear from you guys!!