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

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity 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
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi difolt,

     

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

     

    Regard,

    Frank