Forum Discussion
add column based on selected value
Need help. Say I have two table 1 and table 2. I am using the Col 1 from Table 1 in a slicer and I have created a measure using SELECTEDVALUE on this column. Say I have selected Value 2. Now in tab...
Hi Anonymous ,
You could create a measure like this:
Measure = IF(MAX('Table (2)'[Col 2])in VALUES('Table'[Col 1]),1,0)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are you talking about a measure to be placed in a visual or about a calculated column?
If you mean a calculated column, then the answer is simple: you cannot do it. Values in the columns of model tables are always static.
Best
D
If you mean a calculated column, then the answer is simple: you cannot do it. Values in the columns of model tables are always static.
Best
D
Anonymous Can we put a measure in a visual like a table to filter the details. My ultimate goal is that only. This was a workaround I thought of.
In this method, I want to create a column in an existing table (Table 2) based on a selected value from table 1.
- Yes, that you can do 🙂
Best
D