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 Tabl...
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

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

semsel's avatar
semsel
Frequent Visitor
5 years ago

Thanks a lot! It worked