Forum Discussion
Percentage between two fields in a created table
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
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]))
6 Replies
Hi Peter,
You could try to create calculated measure or calculated column:
- Calculated measure: % = divide(sum(AGC),sum(AGR))
- Calculated column: % = divide(AGC,AGR)
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
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
