Forum Discussion

luispadillazumb's avatar
luispadillazumb
Frequent Visitor
5 years ago
Solved

Sum values from different Time variables.

Hello, i have several meassures that give me some data and i use them to calculate SLA in terms of:   Requirement (transactions) - production (what we can handle) = requirement (100% or less / how ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi luispadillazumb ,

    You can create a measure as below to get Actual Trxns OFF SLA:

    Actual Trxns OFF SLA = 
VAR _curtime =
    SELECTEDVALUE ( 'Requirement'[data Time] )
VAR _pretime =
    CALCULATE (
        MAX ( 'Requirement'[data Time] ),
        FILTER ( ALLSELECTED ( 'Requirement' ), 'Requirement'[data Time] < _curtime )
    )
VAR _preTxnSLA =
    CALCULATE (
        [Txns OFF SLA],
        FILTER ( ALLSELECTED ( 'Requirement' ), 'Requirement'[data Time] = _pretime )
    )
RETURN
    IF ( ISBLANK ( _preTxnSLA ), BLANK (), [FC FF] + _preTxnSLA - [Prod] )

    Best Regards

amitchandak's avatar
amitchandak
Super User
5 years ago

luispadillazumb , Assuming you have a measure [Trxns OFF SLA]. You need to try

 

calculate([Trxns OFF SLA], filter(all(Table) , Table[Datetime] = max(Table[Datetime]) -time(1,0,0)))

  • luispadillazumb's avatar
    luispadillazumb
    Frequent Visitor
    5 years ago

    Hi amitchandak, thank you so much for your support, but some values are missing (in blue):

     

    Have any idea why?