How to Filter a count visual to show data only from a latest import date

[Wilko]

Hi All

I have a Count Visual that is using a measure to get total Storage (Storage GB) from 3 different tables.

Now i have started importing more recent data and only want to show the totals for the most recent import (Latest Data) which i have created as a True False column.

Currently i am using 3 measures to get the total from each table and then use another measure to display the total from each, but am wanting the total to only show the most recent total ie the Total based of Latest Data = True.

These are my current measures

MSTeamsStorageGB = SUM('MSTeams'[StorageGB])
OneDriveStorageGB = SUM(OneDrive[StorageGB])
SharePointStorageGB = SUM(SharePoint[StorageGB])

Total Storage = [MSTeamsStorageGB] + [OneDriveStorageGB] + [SharePointStorageGB]

Is there a way to add a filter by using a True False field called LatestData?

[Uzi2019 · Accepted solution]

Hi @Wilko 
You can either add Latest data in visual filter marked as True always. 

I hope this sloved your query!

[Wilko]

Thanks Phil

Are you able to explain further how this would be applied to the count visual as i'm trying to sort the Total Storage displayed in the Count visual.
If i add a slicer this will filter the content on the entire page correct? Which is not what i want to do.

The Total Storage field is a Measure calculated from the Totals in 3 other tables.

[PhilipTreacy]

Hi @Wilko 

Create a slicer for the True/False LatestDate column.

Regards

Phil