If greater than a number then equal to that number

[android1]

Hi,

I have this calculated column.

Days Off Service in Selected Wk = CALCULATE(COUNTAX(vw_PivotOffService,vw_PivotOffService[Days Off Service]),vw_PivotOffService[Week])

Some results returned are greater than 7. For theses I need to make them 7.

[TomMartens · Accepted solution]

Hey

try this ...

Days Off Service in Selected Wk = 
var tempResult = 
CALCULATE(COUNTAX(vw_PivotOffService,vw_PivotOffService[Days Off Service]),vw_PivotOffService[Week])

return

IF(tempResult > 7, 7, tempResult)

Hopefully, this is what you are looking for.

Regards