Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Relate two table without a Key with conditional

Hi guys Could someone tell me if what I need do is possible? I'm really lose with this problem. I have two tables, in the table "One" I have one colum of "Volume" where you can find tha quantity of...
Need Help DAX
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    Ok. Please try

    Number of Vehicles = 
VAR CurrentVolum = SELECTEDVALUE ( Salles[Volume] )
VAR MAXCapacity = MAX ( Carriers[CAPACIDADE DE] )
RETURN
IF ( 
    NOT ISBLANK( CurrentVolum ),
    ROUNDUP ( DIVIDE ( CurrentVolum, MAXCapacity ), 0 )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi tamerj1 

Thanks a lot for help me, I downloaded you file and I tried to do exactly similar you, but It didn't work. Can you see any mistake in my picture? Find below the translation of the message.

Find bellow the translation of the message from the box

"a table of several values was provided, with a single expected value."

 

 

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 
Ok. Please try

Number of Vehicles = 
VAR CurrentVolum = SELECTEDVALUE ( Salles[Volume] )
VAR MAXCapacity = MAX ( Carriers[CAPACIDADE DE] )
RETURN
IF ( 
    NOT ISBLANK( CurrentVolum ),
    ROUNDUP ( DIVIDE ( CurrentVolum, MAXCapacity ), 0 )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    It worked perfectly well tamerj1.

    Thanks a lot!!