Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Date | Product ID | Project ID | Usage |
Jan 1 | 1234 | ABC | 50 |
Jan 1 | 9876 | ABC | 200 |
Jan 1 | 1234 | XYZ | 25 |
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |