How to divide a measure by a column.

[PSRai]

Hi

I currently have 2 Columns [socket_id] and [Current Ratings] and 1 measure which is MAX Power.

I need to create a NEW COLUMN that is MAX Power/[Current Ratings] as below. It all relates back to the [socket_id]

socket_id            MAX Power                Current Rating                   NEW COLUMN

550                         0.102                                     20                           0.51%

639                         0.027                                     32                           0.08%

666                         0.691                                     20                           3.46%

667                         1.226                                     32                           3.83%

668                         0.415                                     32                           1.30%

669                         0.135                                     32                           0.42%

670                         7.107                                     32                           22.21%

671                         13.373                                   50                           26.75%

672                         2.379                                     32                           7.43%

673                         0.627                                     16                           3.92%

674                         7.643                                     40                           19.11%

675                         3.801                                     32                           11.88%

676                         1.561                                     32                           4.88%

677                         0.79                                        16                           4.94%

678                         2.344                                     20                           11.72%

679                         0.225                                     20                           1.13%

680                         8.336                                     32                           26.05%

681                         8.059                                     50                           16.12%

682                         0.467                                     50                           0.93%

683                         0.108                                     20                           0.54%

[jdbuchanan71 · Accepted solution]

Hello @PSRai 

You should be able to just add the new column like so.

New Column = DIVIDE ( [MAX Power], YourTable[Current Rating] )

If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
 

[PSRai]

@jdbuchanan71 

unfortunately I get the following message - A single value for column 'Current Rating' in table 'readings_true_energy' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

[v-diye-msft]

Hi @PSRai 

Please use the above formula in a calculated column not measure. it should work.