Forum Discussion

difolt's avatar
difolt
Frequent Visitor
7 years ago
Solved

Disable cross filter direction DAX

Hi,   I have relationship like this ( I need to have cross filter direction set to "both") I have report with date slider and when it is not fitered I get data like this But when I fi...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi difolt,

     

    Then I think to create a calculated table should be the only way.

     

    Regard,

    Frank

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Might be able to get there using an ALL to override. 

difolt's avatar
difolt
Frequent Visitor
7 years ago

Greg_Decklerthank you for respons. I did it like this with ALL. I addded new DAx table and new cross fileter single connection

And I get it OK, but I was wondering is there a way to do that without creating new DAX table ?

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi difolt,

     

    Or you can inactive the relationship between the tables and use the USERELATIONSHIP to work around.

     

    Measure = CALCULATE(SUM(sales[Quantity]),USERELATIONSHIP(sales[Customer id],Customer[ID]))

     

    Regards,

    Frank

    • difolt's avatar
      difolt
      Frequent Visitor
      7 years ago

      thank you v-frfei-msft but puting inactive relationship is not a good option for me.

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        7 years ago

        Hi difolt,

         

        Then I think to create a calculated table should be the only way.

         

        Regard,

        Frank