Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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])
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |