Forum Discussion

Lilia's avatar
Lilia
Helper I
9 years ago

Calculate value based on unique values in different table

Hello all, I need of urgent help for some DAX calculation.  Here it is my case: I have three tables  you could see it below   You should know that item type = show the type of the item/ Equ...
Need Help
nickchobotar's avatar
nickchobotar
Skilled Sharer
9 years ago

Lilia

 

You would have to create a bridge table between your Dates Table [LocaitonID] and Location Table [LocaitonID]and create relationships between these tables. Then you can write your count measure.

 

BridgeTable =
SUMMARIZE (
    UNION (
        DISTINCT ( 'DatesTable'[LocaitonID] ),
        DISTINCT ( 'LocationTable'[LocaitonID] )
    ),
    [LocaitonID]
)


 

Nick -

Lilia's avatar
Lilia
Helper I
9 years ago

Hello nickchobotar

I have tried to use your solution but I'm getting error the error below:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Am I doing something wrong ?
Br,

  • nickchobotar's avatar
    nickchobotar
    Skilled Sharer
    9 years ago

    Lilia

     

    You need to finish the  code with [LocationID]  in brackets not just Locations.  I gave you an idea and standard pattern for bridge table. I looked at the data  and it is not easy to interpret it. Could you please post an end result in a table of what exactly you need.


    N -