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 ,
First create a DAX Measure that calculates the count of SLA Achieved
COUNT OF SLA = CALCULATE(COUNT(SLA_ACHIVED), SLA_ACHIEVED = SLA_ACHIEVED)
then create another DAX Measure as follow:
DIVIDE(COUNT OF SLA, COUNT(SLA_ACHIEVED))
Format this one as %