Multiple Percentages from a single column

[GrandWizBiz]

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 🙂 

[Anonymous]

Try changing it to

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

--Nate

[v-jingzhang]

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!