Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Subtract Measure Values from Column

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 Mo...
column
measure
subtract filtered value
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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])
But I end up with this, is there a way to just remove the values if measure 5 is blank?