Is there a way to subtract column values [Rules] from a measure?
My measure which gives me number of working days in a month is:
Measure 5 =
VAR _Month = CALCULATE(COUNT(DimDate[Days in Month]),FILTER(DimDate,'DimDate'[WorkingDays] <>BLANK()))
VAR _lastday=
COUNTROWS(
FILTER(DimDate,'DimDate'[WorkingDays] <>BLANK()))
RETURN
IF ( ISBLANK ( [AbsentByDay] ), BLANK (), _lastday )
Thanks,
@amitchandak I think I have it here:
Measure 9 =
IF(HASONEVALUE('Employee Absence Full Table'[Rules]),[Measure 5],
SUMX(
ALLSELECTED('Employee Absence Full Table'),
[Measure 5]))- SUMX(ALLSELECTED('Employee Absence Full Table'[Rules]),'Employee Absence Full Table'[Rules])
@Niiru1 , The output will be measure not column.
Can you share output in table format?