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 created a new measure which divides values (Average Kupon ist the goal).
On the subtotal level, all avg kupons of the individual rows which go into the subtotal will be added.
This is not wanted. The subtotal should use the same calculation as described for the individual positions.
How is that done?
For a better illustration the current formula:
Akt Kupon = (SP[Kupon]*SP[Marktwert adj/Börsenwert.]/SP[Marktwert adj/Börsenwert.])
Kind regards
Marcus
Hi darlove, I´ll try my best.
Ok. I have a table called "SP"
Column "Kupon" means coupons of a bond, say 4%
Marktwert adj./Börsenwert is the marketvalue, say 1,000,000
The mearure is called Akt Kupon:
no, I won´t pass on this is company stuff. My simple explanation should really explain what I want.
So I will look for another forum if you can´t get may point, no problem.
The world is full of competent and friendly people
Best
Marcus
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |