cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sprasad Member
Member

Custom Column value

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?

IDProductTitleBugs FiledIn
2156ACR3VSTS
2157ACR4VSTS
2159CCR6VSTS
2160CCR7VSTS
2163BCR10VSTS
2165BCR12VSTS
2166BCR13VSTS
2167ACR14JIRA
2168ACR15JIRA
2173ACR17JIRA
2174BCR18JIRA
2175BCR19JIRA
2178CCR19JIRA
2179CCR19JIRA
2180CCR19JIRA
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Custom Column value

@sprasad  Please create a new table as below

 

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

image.png

 

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

 

image.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





2 REPLIES 2
Super User
Super User

Re: Custom Column value

@sprasad  Please create a new table as below

 

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

image.png

 

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

 

image.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





sprasad Member
Member

Re: Custom Column value

Thanks Manohar