Forum Discussion

cgardyne's avatar
cgardyne
Icon for Helper I rankHelper I
9 years ago

Average of Measure in Direct Query mode

Currently I have a measure calculating the days between the start and end dates and getting a value in days: Life In Days = DateDiff(Max([StartDateNzt]), Max(LoanStatusHistories[CreateDateNzt]), DAY...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi cgardyne,

 

>>When I add the AverageX measure below it doesn't filter down. Basically no matter what filter I apply it always gives me the same result?

You can modify the cross filter direction option to both to fix this issue.

 

 

Regards,

Xiaoxin Sheng

cgardyne's avatar
cgardyne
Icon for Helper I rankHelper I
9 years ago

hi Anonymous,

 

 

In my example data I managed to change the filter direction and it worked fine!

 

But the problem is in my live data I can't change the filter direction?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi cgardyne,


    Not sure why you can't modify the relationship, but it seems work on my side.

     

    Maybe you can try to remove the original relationships and re-create it.

     

    Regards,

    Xiaoxin Sheng