Forum Discussion
lookup values from another table
Hi Anonymous ,
(1) We can create a calculated column.
Column = IF('Fact Table'[region]=RELATED('Dimension table'[region]),1,0)(2)We can create a measure.
Measure = IF(SELECTEDVALUE('Fact Table'[Column])==BLANK(),0,1)(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a measure.
Measure = IF(LOOKUPVALUE('dimsention table'[region],'fact table'[region],MAX('dimsention table'[region])) ==BLANK(),0,1)(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, the sample data maybe too simple and some problems might hidden.
If I add a row of data in fact table {C, aaa}, and the required relationship is 1-n, there would be an error, and I tried many times with this method
here is the fact table and relationship, and relevant error:
fact table added one record:
relationship:
error:
Hi Anonymous ,
(1) We can create a calculated column.
Column = IF('Fact Table'[region]=RELATED('Dimension table'[region]),1,0)(2)We can create a measure.
Measure = IF(SELECTEDVALUE('Fact Table'[Column])==BLANK(),0,1)(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your explanation, did you get an error when creating column? Actually there is always an error when I create a column like that, it says parameter is not the correct type