Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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).
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |