Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Another Circular Dependency & Measure returns Last value Anyhelp would be appreciated

Hi Im building a HSE Dashboard and ive only gotten one little hiccup to overcome its building a TRIFR Rate which is more or less a number that we need to know constantly.   The calculated column i ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Also should say the following measure works however i would like it to be over the life of data not 12 months?

 

 

TRIFRv102 = (
        CALCULATE (
            SUM ( TRIFR[MTIIncidents] ) + SUM ( TRIFR[LTIIncidents] )
                ,
            DATESINPERIOD ( TRIFR[Date], LASTDATE ( 'TRIFR'[Date]  ), -12, MONTH )
        )
            * 1000000
    )
        / CALCULATE (
            SUM ( TRIFR[Total Man Hours] ),
            DATESINPERIOD ( TRIFR[Date], LASTDATE ('TRIFR'[Date]  ), -12, MONTH )
        )
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

Does the measure just calculate the values of last 12 months? I tried it in my sample. And it can calculate all the previous values.  Can you please share some sample data and the expected result? Then we will understand your problem clearly.

How to Get Your Question Answered Quickly

 

Best Regards,

Xue Ding

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