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

the_walker's avatar
the_walker
Regular Visitor
7 years ago

Hi,

you can change the crossfilter direction with the "crossfilter()" function. 

Try: Measure = Calculate(SUM(sales[quantity], Crossfilter(Sales[customer_id], customer[id], OneWay))

 

Best, 

Matthias