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

Cross filtering ignore parts of filter logic?

Hello,
Is it possible to deactivate parts of cross filtering logic? The problem: In a matrix table, there are several columns with monthly data. and there are several rows of  data. In this test example three contintents, drillable down to countries and cities.

This data is also displayed in a line chart.

crossfilter1.JPG
What I want is a matrix, which only displays data from latest month (here May), but in the line chart with all month's data on x-axis (here March to May). Using a normal crossdrill results in displaying only the data for the last month, which is filtered and displayed in the matrix table. So there is just one data point in line chart.

 

I've tested some dax logic using the calculate function with ALL parameter which should ignore /deactivate any filters.

Amount Test All = CALCULATE(SUM(test_crossfilter[Amount]);All(test_crossfilter))

However this does not work.

Any ideas?

Thanks....

3 REPLIES 3
Community Support
Community Support

Re: Cross filtering ignore parts of filter logic?

@jpodBerlin,

 

You may try adding measures to Visual level filters.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jpodBerlin
Frequent Visitor

Re: Cross filtering ignore parts of filter logic?

Hello Sam,

 

thanks for your proposal. Maybe I didn't understand it correctly. What I've done so far with visual level filters is a filter on matrix to display only current month's data. (relative date filtering). The line chart has no visual filter on date. Every month should be displaye.

But this results in the described problem. Crossfiltering it results just in May's data (of course).

What is meant with "measures" in your reply?

 

crossfilter2.JPGThere must be some DAX solution to allow crossfiltering on only one dimension (here: Continent) and ignore another (here: date_month).

Thanks, Matthias

Highlighted
D2N2
Frequent Visitor

Re: Cross filtering ignore parts of filter logic?

Hi there, have you found a solutionf for this? I've been struggling to find a solution to this filter behaviour as well.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors