Forum Discussion

HELPMEo_o's avatar
HELPMEo_o
Frequent Visitor
4 years ago

Joining two columns?

I have a dataset with a bunch of columns that list out ratings from 0 to 3000 down the rows, with playerID as the first column. I created 2 pseudo table that holds all of the column names other than...
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

Have you tried using MAX or SELECTEDVALUE for both axises? When I tested this with example data that seemed to work fine.

 


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!


HELPMEo_o's avatar
HELPMEo_o
Frequent Visitor
4 years ago

I might be confused on what you are saying, but I think I've tried and it doesn't seem to work. I ended up stuck on

= CALCULATE(VALUES('Chess Comparison Chart'[Rating]), KEEPFILTERS('Chess Comparison Chart'[Website] = [Selected X Axis]))
and similar for my Y axis, 

But I get an error for using placeholder in a table function. So frustrating. 

Realistically, I'd like 2 measures that each gets 2 columns, rating and player id, then join on playerID into a calculated table and then just call the 2nd and 3rd column of the table as the x and y axis.

I understand that calculated columns don't update with slicers so I'm just stuck. Any ideas are appreciated.