Forum Discussion
Countrows with some filtering
Hi Anonymous
As per my understanding your Requirement:
You want a Card visual in Power BI that displays the total number of shipments for a selected customer and date, but should:
-
Not change when interacting with a map visual (e.g., clicking on Start or End Location)
-
Still reflect filters from customer slicers or other visuals related to the customer or date.
My solution to this is:
1. Create a DAX Measure:
In your Fact Shipments table, create a measure that ignores location filters but still respects customer and date filters:
CustomerShipmentCount = CALCULATE ( COUNTROWS ( Shipments ), REMOVEFILTERS ( Shipments[StartLocation], Shipments[EndLocation] )This ensures:
-
The measure is not affected by filters on
StartLocation andEndLocation
But it still responds to slicers/filters on
Customer andDate2. Use Edit Interactions:
To prevent the Map visual (or any other visual) from affecting the Card:
-
Select the Card visual
-
Go to the top menu: Format → Edit Interactions
-
Click on the Map visual
-
Set the interaction to “None” (the circle-with-slash icon 🚫)
This disables the map's ability to filter the card but keeps other filters (like Customer slicers) intact.
As a Result you will have:
-
Your Card visual displays total shipments for the selected customer and date
-
It ignores interactions from map visuals showing start/end locations
-
It remains dynamic and responsive to slicers for Customer and Date
If you find this insightful, please provide a Kudo and accept this as a solution.
-
Hi Anonymous
As per my understanding your Requirement:
You want a Card visual in Power BI that displays the total number of shipments for a selected customer and date, but should:
-
Not change when interacting with a map visual (e.g., clicking on Start or End Location)
-
Still reflect filters from customer slicers or other visuals related to the customer or date.
My solution to this is:
1. Create a DAX Measure:
In your Fact Shipments table, create a measure that ignores location filters but still respects customer and date filters:
CustomerShipmentCount = CALCULATE ( COUNTROWS ( Shipments ), REMOVEFILTERS ( Shipments[StartLocation], Shipments[EndLocation] )This ensures:
-
The measure is not affected by filters on
StartLocation andEndLocation
But it still responds to slicers/filters on Customer and Date
2. Use Edit Interactions:
To prevent the Map visual (or any other visual) from affecting the Card:
-
Select the Card visual
-
Go to the top menu: Format → Edit Interactions
-
Click on the Map visual
-
Set the interaction to “None” (the circle-with-slash icon 🚫)
This disables the map's ability to filter the card but keeps other filters (like Customer slicers) intact.
As a Result you will have:
-
Your Card visual displays total shipments for the selected customer and date
-
It ignores interactions from map visuals showing start/end locations
-
It remains dynamic and responsive to slicers for Customer and Date
If you find this insightful, please provide a Kudo and accept this as a solution.
Thank you for the answer. However:
interactions is not preffered as I would also use this value in other measures to calculate % etc. Next to that, is there a viceversa way to achieve? One that does not tell to ignore those two columns, but a way to tell to only filter on customer and date? As all other slicer(and visual)selections should not affect this value