Forum Discussion
wynhodgkiss
2 years agoAdvocate II
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 t...
- 2 years ago
Because there is currently no relationship between the measure (Red, Amber or Green) & the table.
- 2 years ago
https://1drv.ms/u/s!ArVbO3X60Juiil9IRWtypHRV5vzp?e=rPyQGM
wynhodgkiss can you please check whether it helps
wynhodgkiss
2 years agoAdvocate II
Because there is currently no relationship between the measure (Red, Amber or Green) & the table.
SanthiyaMallow
2 years agoHelper I
https://1drv.ms/u/s!ArVbO3X60Juiil9IRWtypHRV5vzp?e=rPyQGM
wynhodgkiss can you please check whether it helps
- wynhodgkiss2 years agoAdvocate II
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