Forum Discussion

jamuka's avatar
jamuka
Helper IV
6 years ago
Solved

Divide between two tables

Hello, I want to divide my total sales amount in Sales Table to total visitor number based on location in Visitors Table. Tables have inactive relationship, based on store location (there are two l...
Need Help
Show and Tell
  • AlB's avatar
    AlB
    6 years ago

    Hi jamuka 

    Since the relationship is inactive, place the fields shown from the Sales table in a table visual and create a measure:

    NumVisitors =
CALCULATE (
    SUM ( VistorsT[Visitor] ),
    FILTER (
        ALL ( VistorsT ),
        VisitorsT[Store Location] = SELECTEDVALUE ( SalesT[Store Location] )
            && VisitorsT[Date] = SELECTEDVALUE ( SalesT[Date] )
    )
)

     This will give you the number of visitors in that location and day. Yo can use that to calculate the quotient as required

    Please mark the question solved when done and consider giving kudos if posts are helpful.

     Cheers 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

You either need a better data model or USERELATIONSHIPS.

 

If you made that relationship uni-directional from Sales to Visitors, it wouldn't be inactive.

jamuka's avatar
jamuka
Helper IV
6 years ago

Hello Greg_Deckler  thank you for your reply.

I made the relationship from sales to visitors but couldn't make it active due to ambiguity between Date and Visitors Tables.

I tried to use USERELATIONSHIPS but couldn't finda relevant sample.

 

also I realized my question has missing information therefore I updated it, sorry for inconvenience.