Forum Discussion
Solved
Percentage Help
Hi all Im trying to display the value highlighted below as a percentage, however when i attempt to convert it, it shows 100%. I'm looking to display the percentage for SLA Achieved across the dat...
You are missing a part of the CALCULATE,
Use the formula provided by rajendraongole1
If this helped you, please feel free to send a thumb up
SLA Achieved Percentage =
VAR TotalCount = COUNT('Table'[SLA Status]) -- Count of all SLA statuses
VAR AchievedCount = CALCULATE(COUNT('Table'[SLA Status]), 'Table'[SLA Status] = "SLA Achieved") -- Count of only "SLA Achieved"
RETURN
DIVIDE(AchievedCount, TotalCount, 0)
Hi rpjheeney ,
Across dataset is what measure to compare? plase can you share the DAX used?
Hi, thankyou for the response.
I'm looking to capture the percentage total where the value "SLA Achieved" appears across the table.