Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 filter the data with slider I do not see any more all the customers.
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.
Is it possible to get something like this on last image but keeping cross filter direction to "both"?
Solved! Go to Solution.
Hi @difolt,
Then I think to create a calculated table should be the only way.
Regard,
Frank
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
Might be able to get there using an ALL to override.
@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 ?
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |