Forum Discussion
Solved
Percentage passed SLA
Hi all, Thanks in advance for your help on this, I'm a BI noob and it's taken me a few days to get this far! So through Excel and our CRM, there is a bar and line chart that shows the volume...
I'm assuming that the values displayed in the last image is the "Passing" percentage. In that case create a measure like this:
Measure = DIVIDE( CALCULATE( COUNTROWS(ContactReport) ; ContactReport[Pass/Fail] = "Pass") ; COUNTROWS(ContactReport) ; BLANK() )
Format the measure as % and then place it in your chart and remove the legend. There should only be the measure and the date dimension.
If you dont get the correct result post a picture and we'll take another look 🙂
Br,
J
I'm assuming that the values displayed in the last image is the "Passing" percentage. In that case create a measure like this:
Measure =
DIVIDE(
CALCULATE( COUNTROWS(ContactReport) ; ContactReport[Pass/Fail] = "Pass") ;
COUNTROWS(ContactReport) ;
BLANK()
)
Format the measure as % and then place it in your chart and remove the legend. There should only be the measure and the date dimension.
If you dont get the correct result post a picture and we'll take another look 🙂
Br,
J
