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,
I have a situation where i want to calculate a margin to an existing measure based on a slicer. The current situation is as follows:
Slicers: Services, Materials, Products
Table:
Customer | Sales € |
A | 4000 |
B | 4500 |
C | 1000 |
D | 2000 |
What i want to do, is add a 4th slicer where it says "Margin". When this is selected, Services and Products are multiplied by 1,1.
How would i accomplish this?
Could you provide sample data and expected output after removing sensitive data?
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@CarlsBerg999 , Based on what I got
New column =
Margin = [Sales €] *0.1
New Meausre=
Margin = Sum(Table[Sales €]) *0.1
Hi,
The table above is a visual. The data itself is in multiple tables.
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |