cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
difolt
Frequent Visitor

Disable cross filter direction DAX

Hi,

 

I have relationship like this ( I need to have cross filter direction set to "both")

ss1.png

I have report with date slider and when it is not fitered I get data like this

ss2.png

But when I filter the data with slider I do not see any more all the customers.

ss3.png

I know that it is possible to see all the customer when I have Cross filter direction set to "Single" and on values "Show items with no data"  selected.

ss4.png

Is it possible to get something like this on last image but keeping cross filter direction to "both"?

1 ACCEPTED SOLUTION

Hi @difolt,

 

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

 

Regard,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

6 REPLIES 6
the_walker
Regular Visitor

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

Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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

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

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]))

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

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

Hi @difolt,

 

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

 

Regard,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.