Card showing number of data points being presented after applying filters

[DanGiles]

Hi all, 

I am developing a dashboard which displays the costs of properties in an area. The dashboard uses a map (with dots representing properties, and the size of the dot determined by the property value), in addition to several bar charts breaking down the overall property costs by county and property type. At the top of the dashboard there is a card which shows the overall cost of all of the proporties on the map.

When you click on one of the bars in the bar chart (i.e. 'Gloucestershire', or 'Semi-detached') it highlights these on the map and adjusts the total cost card accordingly. For example, the overall cost of properties in the map is £1.8bn, but when you filter this to show only properties in Gloucestershire the value changes to £400m. This currently works perfectly.

I want to add another card to the dashboard which states the total number of properties used to calculate this total, but I cannot work out how to do this. The value would effectively be the number of data points remaining with all current filters applied. Using the previous example, the card would say something like 6,000 properties, but then when filtering on 'Gloucestershire' the value would change to 1,400 properties.

Any help would be appreciated!

[mh2587]

CALCULATE(
    COUNT('YourTableName'[Properties]),
    REMOVEFILTER()
)

[DanGiles]

Hi Muhammad, 

Apologies, I am a bit of a novice at this. What do I need to do with that formula to get the desired result? Use it to create a Measure?

[mh2587]

If you share the expected result screenshot or mockup data it will help us to answer it

[DanGiles]

Hi Muhammad, 

Thank you for your response. 

I have produced a very quick mock-up of what I am looking for. The 'card' in the top-right is what I would like to add to the dashboard - this card shows the total number of properties being presented (after filtering). With no filters selected this would show the total number of properties in the dataset (e.g. 6,000), but if I were to click on '4 bedrooms' which would then reduce the number of proporties being presented to say 1,000, this would be reflected by the card in the top right.

As I mentioned in my post above, the 'Total Cost' card in the dashboard does this already. E.g. If I clicked on '4 bedrooms' then the total cost would reduce to £0.6bn