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

Anonymous's avatar
Anonymous
Not applicable
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