Forum Discussion

IanT76's avatar
IanT76
Helper I
6 years ago
Solved

Calculate frequency using pre-determined formulae

I'm looking to display a lot of historic safety statistics & frequencies, using our industry's pre-determined calculations, with one example being First Aid Case frequency (FACf); FACf = No. of Fir...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, IanT76 

     

    I'd like to suggest you create a measure as below.

     

    Result = 
var _month = SELECTEDVALUE('Table'[Month])
return
(
    200000*
    CALCULATE(
        SUM('Table'[FAC's]),
        'Table'[Month] = _month
    )
)/
CALCULATE(
    SUM('Table'[Hours Worked]),
    'Table'[Month] = _month
)

     

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, IanT76 

 

I'd like to suggest you create a measure as below.

 

Result = 
var _month = SELECTEDVALUE('Table'[Month])
return
(
    200000*
    CALCULATE(
        SUM('Table'[FAC's]),
        'Table'[Month] = _month
    )
)/
CALCULATE(
    SUM('Table'[Hours Worked]),
    'Table'[Month] = _month
)

 

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • IanT76's avatar
    IanT76
    Helper I
    6 years ago

    Fantastic Allan, thank you!!!