Solved: Having some issues with a DAX measure for SLA with... - Page 2

Anonymous · ‎02-27-2020

Hello all,

I'm having a DAX error about calculating SLA based on True/False values (meaning the percentage of those that met SLA). This seems fairly simple but I receive the following using this data and the following for a measure I created called sla_percent

sla_percent = CALCULATE(COUNT('ServiceNow Incident Data'[target_sla]), 'ServiceNow Incident Data'[target_sla] = "True") / CALCULATE(COUNT('ServiceNow Incident Data'[target_sla]))

Thoughts anyone on why I receive this error and what I might be able to do to remedy it?

Anonymous · ‎02-29-2020

sla_percent =
DIVIDE (
	CALCULATE (
	    COUNTROWS ( 'ServiceNow Incident Data' ),
	    // This column must be a BOOLEAN column.
	    // Otherwise it'll not work.
	    KEEPFILTERS ( 'ServiceNow Incident Data'[target_sla] )
	),
    COUNTROWS ( 'ServiceNow Incident Data' )
)

Best

D

View solution in original post

Having some issues with a DAX measure for SLA with True and False

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024