Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
No this won't work it adds value to all types and repetation of cost
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
thanks
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |