Is there a way to replace 2.5 in Measure 5.0 with this IF statement [Rules]?
Measure 5.0 =
VAR _Month = CALCULATE(COUNT(DimDate[Days in Month]),FILTER(DimDate,'DimDate'[WorkingDays] <>BLANK()))
VAR _lastday=
COUNTROWS(
FILTER(DimDate,'DimDate'[WorkingDays] <>BLANK()))-2.5
RETURN
IF ( ISBLANK ( [AbsentByDay] ), BLANK (), _lastday )
Rules =
VAR searcind = SEARCH("Industr",'Query1'[GRADE_NAME],1,BLANK())
VAR searcnotind = FIND("Industr",'Query1'[GRADE_NAME],1,-1)
VAR duration510 = IF(searcind<>BLANK(),IF(AND('Query1'[Total Years - Employment] >=0,'Query1'[Total Years - Employment] <5),CALCULATE(23.5/12),BLANK()),BLANK())
VAR notindnot10 = IF(AND('Query1'[Total Years - Employment] <10,searcnotind),CALCULATE(25/12))
VAR ind5 = IF(AND('Query1'[Total Years - Employment] >= 5,searcind),CALCULATE(25.5/12),duration510)
VAR notind10 = IF(AND('Query1'[Total Years - Employment] >= 10,searcnotind),CALCULATE(30/12),notindnot10)
RETURN
IF(ind5<>BLANK(),ind5,notind10)
https://www.dropbox.com/s/xjagu2e89p5fe4a/Sample4.pbix?dl=0
