cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RomainTo
Frequent Visitor

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[Encours_1]+10,KEEPFILTERS('Dimension Divers'[devise]="USD"))
 
But as you can see below.. As soon as we add a constant number to the CALCULATE the KEEPFILTERS function is not working.
It puts the value everywhere...
 
RomainTo_0-1666945493515.png

I have do some further testing and it seems that as soon as we do an addition in the CALCULATE then it won't work (but it works for a multiplication !). I have also tried to put the addition after the CALCULATE but same issue..

Do you have any idea ?

 

Thanks for your help.

 

Romain

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

Try

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

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

Try

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

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors