Custom Column value

[sprasad]

I have this table and I want to find out the count of Bugs Filed in (JIRA & VSTS) and for each product.

Then I want to divide the count of bugs filed in JIRA by the Bugs Filed in VSTS

Creating new column I am able to get the count of Bugs for each filter (JIRA & VSTS) of the "Bugs FiledIn" column but I am not finding a way to divide and get the value in %age like:

Product  A 3/2*100 where there is 3 counts of Bugs filed in JIRA and 2 Counts filed in VSTS. The same is applicable to below

Product C 3/2*100

Product B 2/3*100

Can anyone help me to get the correct expression?

ID	Product	Title	Bugs FiledIn
2156	A	CR3	VSTS
2157	A	CR4	VSTS
2159	C	CR6	VSTS
2160	C	CR7	VSTS
2163	B	CR10	VSTS
2165	B	CR12	VSTS
2166	B	CR13	VSTS
2167	A	CR14	JIRA
2168	A	CR15	JIRA
2173	A	CR17	JIRA
2174	B	CR18	JIRA
2175	B	CR19	JIRA
2178	C	CR19	JIRA
2179	C	CR19	JIRA
2180	C	CR19	JIRA

[PattemManohar · Accepted solution]

@sprasad  Please create a new table as below

Test195Out = SUMMARIZE(Test195Grouping,Test195Grouping[Product],Test195Grouping[BugsFiledIn],"Count",COUNT(Test195Grouping[ID]))

Then add a new column to the above table as below (change the format of column to Percentage)

%Val = 
VAR _CurrProduct = Test195Out[Product]
VAR _JIRA = LOOKUPVALUE(Test195Out[Count],Test195Out[BugsFiledIn],"JIRA",Test195Out[Product],_CurrProduct)
VAR _VSTS = LOOKUPVALUE(Test195Out[Count],Test195Out[BugsFiledIn],"VSTS",Test195Out[Product],_CurrProduct)
RETURN _JIRA/_VSTS

Final output will be

[sprasad]

Thanks Manohar