Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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])
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 6 | |
| 6 |