Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How create a condition with LOOKUPVALUE

Hi!  I have two different datas, as in the tables below     country date type value peru 01/01/2023 old 5000 peru 02/01/2022 old 4000 peru 03/01/2022 old 8000 peru 04/...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Are the other way that you don't need to create a relationship?

For me, this way it doesn't work

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, Anonymous 

try below solution without using of relationship bw tables
Measure (1).

valueold =
CALCULATE(SUM(a1[value]),
           a1[type]="old",
           KEEPFILTERS(a1[country2]=SELECTEDVALUE(a2[country1])&&
                        a1[date]=SELECTEDVALUE(a2[date1])
                      )
         )

 


 

 Measure (2).
valuenew =
CALCULATE(SUM(a1[value]),
             a1[type]="new",
             KEEPFILTERS(a1[country2]=SELECTEDVALUE(a2[country1])&&
                           a1[date]=SELECTEDVALUE(a2[date1])
                        )
        )

 

which give you below outout 

 
here i am not use relationship bw table

 

i am provide link of  .pbix  file. refer Here 

 

Did i answer your question? Mark my post as a solution which help other people to find  fast and easily.