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.
V-lianl-msft
Community Support
Community SupportHi 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.