Forum Discussion

HarryS's avatar
HarryS
Icon for Helper I rankHelper I
7 years ago
Solved

use relationship and filtering

Hi everyone, am new to powerbi and these forums have been a great help to me so far. However, I have found myself stuck on a particular issue when using the ‘userelationship’ and  'filter' function. ...
Need Help
Tips and Tricks
  • HarryS's avatar
    HarryS
    7 years ago

    HI Jimmy, I manged to reslove this issue by using it as a 'variable'. Also I had my relationship both ways not single which was the causing an issue as well. 

     

    Thanks,

    Harry

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

HarryS ,

 

The issue may be caused by direction in table relationship. If 'Date_Reference' and 'code' are two dimentional tables, I would suggest you to use CROSSFILTER() and set the filter direction instead of two 'FILTER' statement.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.