Creating a connection between a measure and a column *Is it possible?*

[erodriguez6393]

I have a table that contains Department/Quality Score/Payout. Another table that contains Name/Department and Inspection Result. I created a measure to create a quality score based on the inspection results but I can only tie the two tables with the "Shop" column and not both Shop and Quality Score which is a column on the 1st table but a measure on the other. The objective would be to retreive the respective payout for that Quality Score and department.

[pranit828]

HI @erodriguez6393 

Measures are calculated and is to be considered as a variable.

It cannot be tied.

Change the measure to a column.

[erodriguez6393]

@pranit828 Thank oyu for the feed back, the only problem I run into is that the data is captured at the single inspection level, we calculate Quality Score as a total of all inspections but we also separate them by shop or time frame. I thought that a column would not be able to adapt based on filters? For example here you can see one associate at the accessory level but we would only want a Quality score at the shop level and for the date selected on a slicer.

[pranit828]

Hi @erodriguez6393 

You need to have two columns in that case if you are looking for leveraging the relationship feature.

[erodriguez6393]

Im not sure I understand, what would the two columns be?