Forum Discussion

Libin7963's avatar
Libin7963
Icon for Helper II rankHelper II
1 year ago
Solved

one to one relationship issue

I have two tables with one to one relationship as shown below where table 1 is direct query in actual table and 2 is import. In the table visual it is not displaying the rows for 5 and 6 (both refere...
Need Help
  • lucadelicio's avatar
    lucadelicio
    1 year ago

    Hi try to manage the output and the number of rows that appear throught a measure like this:
    Measure =
    IF(ISBLANK(MAX(Table2[Reference])), "", MAX(Table2[Reference]))
    Try and let me know.

lucadelicio's avatar
lucadelicio
Icon for Impactful Individual rankImpactful Individual
1 year ago

Hi try to manage the output and the number of rows that appear throught a measure like this:
Measure =
IF(ISBLANK(MAX(Table2[Reference])), "", MAX(Table2[Reference]))
Try and let me know.

Libin7963's avatar
Libin7963
Icon for Helper II rankHelper II
1 year ago

Wow, it worked. thank you. 

  • lucadelicio's avatar
    lucadelicio
    Icon for Impactful Individual rankImpactful Individual
    1 year ago

    You are welcome.