Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can I make a calculation (New value) on a single line (only in one row) of the table, by selecting from a list containing numbers (1-4).
For example, I select the number 1 from the list and I would like to apply the statement in line 1, column New Value, of the table.
See in the picture below how I would like to work.
Solved! Go to Solution.
@kkapsokavadis wrote:
Finally, i found the solution.
i've made 2 measures, one for each Id (Row Id & Selection Id).
Sum_Choises_PK = SUM( Choises[Choises_PK] )
Sum_wif_id = SUM(wif[id])
Then i've made the Measure for "what if Value"
wif Value = if (wif[Sum_wif_id]=Choises[Sum_Choises_PK]; sum(wif[Value]) + sum(wif[Value]) * Parameter[Parameter Value] / 100 ; sum(wif[Value]))
Now, im faced with with a new (2) problems:
As you can see:
a. The Total of the [wif Value] is incorrect. The correct value is 120.000
b. The Calculated Column [New Running total] --> (New Quick Measure -> Running Total), also is incorrect
New Running total =
CALCULATE(
'wif'[wif Value];
FILTER(
ALLSELECTED('wif'[id]);
ISONORAFTER('wif'[id]; MAX('wif'[id]); DESC)
)
)
any suggestions are welcome!!
You can try to change the measure a little bit.
wif Value = VAR summurizedTbl = SUMMARIZE ( wif, wif[id], "total value", IF ( wif[id] = Choises[Sum_Choises_PK], SUM ( wif[Value] ) + SUM ( wif[Value] ) * Parameter[Parameter Value] / 100, SUM ( wif[Value] ) ) ) RETURN IF ( HASONEVALUE ( wif[id] ), IF ( wif[Sum_wif_id] = Choises[Sum_Choises_PK], SUM ( wif[Value] ) + SUM ( wif[Value] ) * Parameter[Parameter Value] / 100, SUM ( wif[Value] ) ), SUMX ( summurizedTbl, [total value] ) )
See more details in the attched pbix file.
Finally, i found the solution.
i've made 2 measures, one for each Id (Row Id & Selection Id).
Sum_Choises_PK = SUM( Choises[Choises_PK] )
Sum_wif_id = SUM(wif[id])
Then i've made the Measure for "what if Value"
wif Value = if (wif[Sum_wif_id]=Choises[Sum_Choises_PK]; sum(wif[Value]) + sum(wif[Value]) * Parameter[Parameter Value] / 100 ; sum(wif[Value]))
Now, im faced with with a new (2) problems:
As you can see:
a. The Total of the [wif Value] is incorrect. The correct value is 120.000
b. The Calculated Column [New Running total] --> (New Quick Measure -> Running Total), also is incorrect
New Running total =
CALCULATE(
'wif'[wif Value];
FILTER(
ALLSELECTED('wif'[id]);
ISONORAFTER('wif'[id]; MAX('wif'[id]); DESC)
)
)
any suggestions are welcome!!
@kkapsokavadis wrote:
Finally, i found the solution.
i've made 2 measures, one for each Id (Row Id & Selection Id).
Sum_Choises_PK = SUM( Choises[Choises_PK] )
Sum_wif_id = SUM(wif[id])
Then i've made the Measure for "what if Value"
wif Value = if (wif[Sum_wif_id]=Choises[Sum_Choises_PK]; sum(wif[Value]) + sum(wif[Value]) * Parameter[Parameter Value] / 100 ; sum(wif[Value]))
Now, im faced with with a new (2) problems:
As you can see:
a. The Total of the [wif Value] is incorrect. The correct value is 120.000
b. The Calculated Column [New Running total] --> (New Quick Measure -> Running Total), also is incorrect
New Running total =
CALCULATE(
'wif'[wif Value];
FILTER(
ALLSELECTED('wif'[id]);
ISONORAFTER('wif'[id]; MAX('wif'[id]); DESC)
)
)
any suggestions are welcome!!
You can try to change the measure a little bit.
wif Value = VAR summurizedTbl = SUMMARIZE ( wif, wif[id], "total value", IF ( wif[id] = Choises[Sum_Choises_PK], SUM ( wif[Value] ) + SUM ( wif[Value] ) * Parameter[Parameter Value] / 100, SUM ( wif[Value] ) ) ) RETURN IF ( HASONEVALUE ( wif[id] ), IF ( wif[Sum_wif_id] = Choises[Sum_Choises_PK], SUM ( wif[Value] ) + SUM ( wif[Value] ) * Parameter[Parameter Value] / 100, SUM ( wif[Value] ) ), SUMX ( summurizedTbl, [total value] ) )
See more details in the attched pbix file.
Works Perfect!
Thanx!!!!
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |