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
     

     

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

Hello, nope, it doesn't work. Link to the file.

govindarajan_d's avatar
govindarajan_d
Icon for Super User rankSuper User
2 years ago

Hi DmitryAD7 ,

Try this:

I have used CONCATENATEX to build a string that contains the values selected in slicer and check if it is equal to "D1, D2"

 

VAR _select =
    CONCATENATEX(
        VALUES('Dataset'[D]),
        'Dataset'[D],
        ", "
    )
VAR _d1_value =
    CALCULATE ( [Total Value], FILTER ( 'Dataset', 'Dataset'[D] = "D1" ) ) * 1.25
VAR _d2_value =
    CALCULATE ( [Total Value], FILTER ( 'Dataset', 'Dataset'[D] = "D2" ) )
VAR _default_value =
    CALCULATE ( [Total Value], FILTER ( 'Dataset', 'Dataset'[D] = "_select" ) )
VAR Result =
    IF (
        CONTAINSSTRING(_select,"D1, D2"),
        CALCULATE ( _d1_value + _d2_value ),
        _default_value
    )
RETURN
    Result

 

 

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

    Sorry, but it still doesn't work.