Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

CALCULATE with KEEPFILTERS not working when adding constant

Hello 🙂   I am facing an issue on my visual.   I have created two measures :  test1 = CALCULATE(Mesures[Encours_1],KEEPFILTERS('Dimension Divers'[devise]="EUR")) test2 = CALCULATE(Mesures[En...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    test2 =
CALCULATE (
    Mesures[Encours_1]
        + IF ( SELECTEDVALUE ( 'Dimension Divers'[devise] ) = "USD", 10 ),
    KEEPFILTERS ( 'Dimension Divers'[devise] = "USD" )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

test2 =
CALCULATE (
    Mesures[Encours_1]
        + IF ( SELECTEDVALUE ( 'Dimension Divers'[devise] ) = "USD", 10 ),
    KEEPFILTERS ( 'Dimension Divers'[devise] = "USD" )
)