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'm sure this is a fairly simple explanation but i'm having trouble doing this. Do i do this in a new measure?
Basically I have my data in a table which is a visualization as listed below what I want to do it add a new column in the table which is:
The table has been summed up by Current_AE
Lost_Business prem / (Lost_Business prem + Current Minimum) to give a %
Can anyone help?!
Current_AE | Current_Minimum | Lost_Business_prem |
a | 1952533 | 2840919 |
b | 2156028 | 2,840,919 |
c | 1621874 | 31946654 |
d | 1549861 | 2,840,919 |
Solved! Go to Solution.
Hi @Anonymous
Are [Lost_Business prem] and [Current Minimum] explicit measures? If so, you can just create an additional measure, format it as %, and place it in your visual
NewMeasure = DIVIDE( [Lost_Business prem], [Lost_Business prem] + [Current Minimum])
If they are implicit measures, create explicit ones (writing the formula).
Hi @Anonymous
Are [Lost_Business prem] and [Current Minimum] explicit measures? If so, you can just create an additional measure, format it as %, and place it in your visual
NewMeasure = DIVIDE( [Lost_Business prem], [Lost_Business prem] + [Current Minimum])
If they are implicit measures, create explicit ones (writing the formula).
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |