Using measure how to add the other table some number into current table

[Gokul_G16]

Dear All,

Good Day,

I would like to need your support and  exectue the below shown calculation in DAX. Since have tried some All and ALL Expected calculation it won't come sorted out. need you help on.

Important
In that  b row should add manully 10 number the same row against B row category dax.

	data	Additional value	Result column
Category	license	projected	utilized
a	50		50
b	70	10	80
c	90		90
d	110		110

[v-xuxinyi-msft · Accepted solution]

Hi @Gokul_G16 

You can create two calculated columns as follow.

projected = IF('Table'[Category] = "b", 10, BLANK())

Utilized = [license] + [projected]

Is this the result you expect?

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.