How to create measure with fixed values

[adityavighne]

Hi All,

I have fixed cost for

Item A = 1000

Item B = 5000

and table with data

Type	Name	Cost
Item C	ABC	100
Item C	EFG	5000
Item D	tyu	2356
Item C	POL	5547
Item E	GGF	6328
Item E	LAT	9514

I need output as measure 

Total Cost = Item A + Item B + Item C+ Item D + Item E

Type	Cost
Item A	1000
Item B	5000
Item C	10674
Item D	2356
Item E	15842

[adityavighne]

No this won't work it adds value to all types and repetation of cost

[PijushRoy]

Hi @adityavighne 

Please use the DAX in measure

Cost = 
VAR _A = 1000
VAR _B = 5000
RETURN
_A + _B + Calculate(SUM('YourTable'[Cost]),'YourTable'[Type] IN {"Item C","Item D","Item E"})

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[adityavighne]

thanks

[PijushRoy]

@adityavighne 

Is it working now?
If not working, can you please share screenshot what value the the measure returning and what is expected

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin