Forum Discussion
What's wrong with this Dax?
My Column is below
GetEventlistCalc =
IF (
(('KPIData'[KPI] = “Login” || 'KPIData'[KPI] = “GetEventList”)
&& 'KPIData'[KPI]>AVERAGE('KPIData'[95%ResponseTimeRollUpIterationWise])),
"Passed","Failed"
)
Intention is to have a Barchart showing KPI data and Login Response time for each Requests like Login and GetEventList if KPI > Response time ,Barchart will show pass and fail other wise.
1 Reply
- Phil_Seamark
Microsoft Employee
What does the data in your KPI table look like?
