Forum Discussion

Advocate II

2 years ago

Solved

Using measure for join to existing table

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&colon;image/jpeg;Base64,abaea..........
Amber	data&colon;image/jpeg;Base64,avaea..........
Green	data&colon;image/jpeg;Base64,adaea..........

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

wynhodgkiss
2 years ago
Because there is currently no relationship between the measure (Red, Amber or Green) & the table.
SanthiyaMallow
2 years ago
https://1drv.ms/u/s!ArVbO3X60Juiil9IRWtypHRV5vzp?e=rPyQGM
wynhodgkiss can you please check whether it helps

SanthiyaMallow
Helper I
2 years ago
Hi wynhodgkiss , why cant we return binary image using 'Table name'[binary_image] ? can you please share any sample data for the actual usecase?
wynhodgkiss
Advocate II
2 years ago
Because there is currently no relationship between the measure (Red, Amber or Green) & the table.
- SanthiyaMallow
  Helper I
  2 years ago
  https://1drv.ms/u/s!ArVbO3X60Juiil9IRWtypHRV5vzp?e=rPyQGM
  wynhodgkiss can you please check whether it helps
  - wynhodgkiss
    Advocate II
    2 years ago
    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