Forum Discussion

DmitryAD7's avatar
DmitryAD7
Icon for Helper I rankHelper I
2 years ago
Solved

IF and SELECTEDVALUE Condition

I need a measure that will calculate the following condition: if only two atributes D1 and D2 are selected in the slicer, the D1 value (100) should be multiplied (1.25) and then summ with the D2 valu...
  • talespin's avatar
    talespin
    2 years ago

    hi DmitryAD7 

     

    Please try this measure 

     

    Sales with Condition =
    VAR _CountCheck = COUNT('Dataset'[D])
    VAR _val = CALCULATE ( [Total Value], REMOVEFILTERS('Dataset'[D]), 'Dataset'[D] = "D1" )
    VAR _d1_value = _val*1.25
    VAR _d2_value =
        CALCULATE ( [Total Value], REMOVEFILTERS('Dataset'[D]), 'Dataset'[D] = "D2" )
    VAR _default_value =
        CALCULATE ( [Total Value], REMOVEFILTERS('Dataset'[D]), VALUES('Dataset'[D]) )
    VAR Result =
        IF ( CONTAINSROW(VALUES('Dataset'[D]), "D1")  && CONTAINSROW(VALUES('Dataset'[D]), "D2") && _CountCheck = 2,
            _d1_value + _d2_value,
            _default_value
        )
    RETURN
        Result
     

     

talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

hi DmitryAD7 

 

Please try this measure 

 

Sales with Condition =
VAR _CountCheck = COUNT('Dataset'[D])
VAR _val = CALCULATE ( [Total Value], REMOVEFILTERS('Dataset'[D]), 'Dataset'[D] = "D1" )
VAR _d1_value = _val*1.25
VAR _d2_value =
    CALCULATE ( [Total Value], REMOVEFILTERS('Dataset'[D]), 'Dataset'[D] = "D2" )
VAR _default_value =
    CALCULATE ( [Total Value], REMOVEFILTERS('Dataset'[D]), VALUES('Dataset'[D]) )
VAR Result =
    IF ( CONTAINSROW(VALUES('Dataset'[D]), "D1")  && CONTAINSROW(VALUES('Dataset'[D]), "D2") && _CountCheck = 2,
        _d1_value + _d2_value,
        _default_value
    )
RETURN
    Result
 

 

  • DmitryAD7's avatar
    DmitryAD7
    Icon for Helper I rankHelper I
    2 years ago

    Thanks a lot!