Percentage between two fields in a created table

[Peter]

Based on 2 merged reports I could create following table, as a last step I need as well extra columns which are calculating the % of "NewColumn AGC/AGR" versus the "Count of Serial Number".

How can this be done?

thx

[tringuyenminh92]

Hi @Peter,

You could try to create calculated measure or calculated column:

• Calculated measure: % = divide(sum(AGC),sum(AGR))
• Calculated column: % = divide(AGC,AGR)

[Peter]

some more info

I need to divide NewColumn.AGC (and AGR) by Count of Serial Number.

Both are dynamic. It's a report table, not a DATA file...

Can I make a data table of it? then I could create the extra fields I need?

thx

[tringuyenminh92]

Hi @Peter

I dont get you, could you please show your sample data of transaction and expectation? So I will know what we have and what we need to do

[Peter]

Sure

NewColumn.AGC and NewColumn.AGR are representing the presence of a certain option on a serialnumber sold (Count of Serial Number).

I now have then in volumes, but would also need the percentage of serialnumbers that are having the option.

[tringuyenminh92 · Accepted solution]

Hi @Peter,

As your response from message, I would like to update the final formula as your expectation for reference purpose, so another people could refer this when they have same concern

% AGC = DIVIDE( sum('BI report+ OPT'[NewColumn.AGC]), DISTINCTCOUNT('BI report+ OPT'[Serial Number])  )

% AGR = DIVIDE(SUM('BI report+ OPT'[NewColumn.AGR]),DISTINCTCOUNT('BI report+ OPT'[Serial Number]))

[tringuyenminh92]

Hi @Peter,

So far i dont understand what your expectation, but let me guess, you want calculate % of AGC/count of serialnumber and % AGR /count of serial number. Am i correct? if that, you could try with calculated measure:

% AGC = divide(sum(AGC),count(serialnumbercolumn))

% AGR = divide(sum(AGR),count(serialnumbercolumn))

It's better if I could analyze your data or your data sample to ensure above formua is correct.