Using measure for join to existing table

[wynhodgkiss]

Hi, probably a simple answer so apologies for empty headedness.

I have a simple RAG measure:

RAG = if([MS% - National MS%]<-0.05,"Red",if([MS% - National MS%]<0,"Amber","Green"))

and a table with the 3 RAG options and a corresponding binary image to display using Simple Image:

Red	data:image/jpeg;Base64,abaea..........
Amber	data:image/jpeg;Base64,avaea..........
Green	data:image/jpeg;Base64,adaea..........

how can I join the 2 together so that the measure filters the table?

[wynhodgkiss · Accepted solution]

Because there is currently no relationship between the measure (Red, Amber or Green) & the table.

[wynhodgkiss · Accepted solution]

Because there is currently no relationship between the measure (Red, Amber or Green) & the table.

[SanthiyaMallow · Accepted solution]

https://1drv.ms/u/s!ArVbO3X60Juiil9IRWtypHRV5vzp?e=rPyQGM 
@wynhodgkiss  can you please check whether it helps

[wynhodgkiss]

That does work, in a table viz, the problem is Simple Image only accepts columns as fields but I can work around that using a bit of creative formatting

[SanthiyaMallow]

Hi @wynhodgkiss , why cant we return binary image using 'Table name'[binary_image] ? can you please share any sample data for the actual usecase?