cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
difolt Frequent Visitor
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

Accepted Solutions
Community Support Team
Community Support Team

Re: Disable cross filter direction DAX

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 other members find it more quickly.
6 REPLIES 6
Super User
Super User

Re: Disable cross filter direction DAX

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


Check-out my Back to School contest submission: Dinosaurs!

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
difolt Frequent Visitor
Frequent Visitor

Re: Disable cross filter direction DAX

@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 ?

Community Support Team
Community Support Team

Re: Disable cross filter direction DAX

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 other members find it more quickly.
difolt Frequent Visitor
Frequent Visitor

Re: Disable cross filter direction DAX

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

Community Support Team
Community Support Team

Re: Disable cross filter direction DAX

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 other members find it more quickly.
the_walker Visitor
Visitor

Re: Disable cross filter direction DAX

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 111 members 1,723 guests
Please welcome our newest community members: