Forum Discussion
spandy34
Responsive Resident
Responsive Resident25% Variance between columns
I have a table that records visits and records the planned hours per visit and the actual hours carried out. I want a measure that calculates the number of records where the actual hours is 25%...
Thats fabulous its worked - I really appreciate your help as always.
tamerj1
Community Champion
Community ChampionHi spandy34
please try
Measur1 =
COUNTROWS (
FILTER ( 'Table', 'Table'[Actual Hours] >= 'Table'[Planned Hours] * 1.25 )
)
Measur1 =
COUNTROWS (
FILTER ( 'Table', 'Table'[Actual Hours] <= 'Table'[Planned Hours] * 0.75 )
)
spandy34Thats fabulous its worked - I really appreciate your help as always.