Forum Discussion

PS_78's avatar
PS_78
Helper II
2 years ago
Solved

Issue with Divide in Summarize table

Hello - I am running into an issue with DIVIDE in Summarization. I have a table with list of tickets and I need to create a summarize table (creating summarize table as I have to do it for multiple m...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    % Bug Fixes = 
var a = ADDCOLUMNS(SUMMARIZE (
    Tickets,
    [Created Year],
    [Created Week]),
   "Incidents",
        CALCULATE(COUNTROWS (Tickets),Tickets[Issue Type] = "Incident"),
    "# of Tickets",
        CALCULATE(COUNTROWS (Tickets),Tickets[Issue Type] in { "Incident", "Service request"})
        )
return ADDCOLUMNS(a,"% Bug Fixes_Msr",DIVIDE([Incidents],[# of Tickets]))
lbendlin's avatar
lbendlin
Super User
2 years ago

Do you maybe need a measure instead of a calculated table?

PS_78's avatar
PS_78
Helper II
2 years ago

Hello lbendlin  - The main table I have is raw data and I will have to generate multiple metrics (summarizing at week level) based on it, show each of the metric in matrix visual, combine it with a different dataset to get target into the calculated table, do the color code based on target Vs actual values. Hence I am going with calculated table.

Thanks,

Phani

 

Thanks,

Phani