Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

trying to filter my results using a virtual table

Hi, i have been trying to solve this problem for several days and looking for assistance. I am trying to provide a report with 2 visuals.  The first visual will show all the Projects that have a total usage for the month greater than a minimum usage filter specified by the user with a slicer.  The second visual is a list of the Products and their sum usage filtered by only the projects that are equal or greater than the minimum usage filter.  I am able to get the projects visual to work by creating a measure to check if the total usage is equal or greater than the slicer value and then filter the visual by that check.  My problem is that i can not figure out how to get the Projects visual to display correctly. 

 

I tried to create the following measure but the visual is not correct.  the grand total value in the table is correct but the table keeps filtering the list to only show Products that have total usage greater than the slicer value instead of showing all products regardless of their usage for the projects that meet my criteria.

 

 

 

Credits by project min credit filter =
var _ProjectFilterTable =
FILTER(
  ADDCOLUMNS(
     SUMMARIZE(
        UsageTable,
        UsageTable[ProjectID]
      ),
      "UsageFilterCheck", IF([TotalUsage] >= SELECTEDVALUE('Usage Filter'[Value]), 1, 0)
      ),
      [UsageFilterCheck] = 1
)

var _ProjectFilterList =
SUMMARIZE(
   _ProjectFilterTable,
   UsageTable[ProjectID]
)

return
CALCULATE(
   [TotalUsage],
   TREATAS(_ProjectFilterList, UsageTable[ProjectID])
)

 

 

 

Here is an example of my data table:

DateProduct IDProject IDUsage
Jan 11234ABC50
Jan 19876ABC200
Jan 11234XYZ25

 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.