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.
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))
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?
There must be some DAX solution to allow crossfiltering on only one dimension (here: Continent) and ignore another (here: date_month).