Forum Discussion

semsel's avatar
semsel
Frequent Visitor
5 years ago
Solved

Show a Summarized value from a different table without relationship

Following is the Data Structure I have.

In Quotes Table QuoteID is Unique whereas in Working Hours table the Combination of Date and user is Unique.

I need to have a column n the Working Hours Table the total No of Quotes the User created on a particlar day.

 

How do I link the User and Date to group by the Count, I checked in relationships it is not possible to have multiple coumns as a link.

Moreover not everything is common between 2 tables. I dont want to display the users who never created any quotes in my visual, as WorkingHours table is a Global list and involves all users in the company.

Do I need an additinal table here that merges data from both sides ? Newbie here. Please help.

Both tables are really big, hence I need to consider the best way

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi semsel ,

     

    Refer the measure.

    Measure = CALCULATE(COUNT(quotes[quote]),FILTER(quotes,quotes[date]=SELECTEDVALUE('working hours'[date])&&quotes[user]=SELECTEDVALUE('working hours'[user])))

     

    Best Regards,

    Jay

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi semsel ,

     

    Refer the measure.

    Measure = CALCULATE(COUNT(quotes[quote]),FILTER(quotes,quotes[date]=SELECTEDVALUE('working hours'[date])&&quotes[user]=SELECTEDVALUE('working hours'[user])))

     

    Best Regards,

    Jay