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 )
)
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!!