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
     

     

nareshr89's avatar
nareshr89
Icon for Helper II rankHelper II
2 years ago

Try this

 

 

Sales with Condition =
VAR _select = SELECTEDVALUE ( '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 _defualt_value =
CALCULATE ( [Total Value], FILTER ( 'Dataset', 'Dataset'[D] = "_select" ) )

VAR Result =
IF ( _select = "D1" && _select = "D2", CALCULATE(_d1_value+_d2_value),_defualt_value)

 

If it doesn't work, share a sample PBIX file.

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

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