Forum Discussion

spandy34's avatar
spandy34
Responsive Resident
2 years ago
Solved

25% 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%...
  • tamerj1's avatar
    tamerj1
    2 years ago

    Hi 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 )
    )

  • spandy34's avatar
    spandy34
    2 years ago

    Thats fabulous its worked - I really appreciate your help as always.

tamerj1's avatar
tamerj1
Community Champion
2 years ago

Hi 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 )
)

  • spandy34's avatar
    spandy34
    Responsive Resident
    2 years ago

    Thats fabulous its worked - I really appreciate your help as always.