Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @Wilko
You can either add Latest data in visual filter marked as True always.
I hope this sloved your query!
Hi @Wilko
You can either add Latest data in visual filter marked as True always.
I hope this sloved your query!
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.
Hi @Wilko
Create a slicer for the True/False LatestDate column.
Regards
Phil
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |