Forum Discussion

GrandWizBiz's avatar
GrandWizBiz
New Member
3 years ago

Multiple Percentages from a single column

Hi,

 

Work in the managed services industry, I have a single column called "Priority", which tracks the urgency of tickets within a ticketing system, results can be 1,2,3,4. 

 

Each priority has its own unique SLA (a target) which pushes analysts to pick tickets up in agreed times.  

 

I already have a measure which tracks total SLA adherance across ALL tickets but I want to be able to break it down for each individual priority.

 

Much current forumla is: 

MTTTPercent = ((100) / COUNT(FAULTS[SLANUM])) * SUM(FAULTS[SLANUM])
 
How would I go about introducing "Priority" into this forumla? I seem to be hitting a mental brick wall. 
 
Thanks 🙂 

 

 

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi GrandWizBiz 

     

    Your current measure is dynamic. You can add "Priority" column and the measure into a table visual to see its result for every priority. The results should be different. 

     

    If the results cannot meet your need, can you please share some dummy data and expected output in table format? Please explain how you want to break it down for each individual priority too. This can help us understand your requirement better and try to provide a detailed solution. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Try changing it to

     

    MTTTPercent = ((100) / List.Count(FAULTS[SLANUM])) * List.Sum(FAULTS[SLANUM])

     

    --Nate