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.
Solved! Go to Solution.
@Anonymous
Try this pattern
Measure = COUNTROWS ( FILTER ( VALUES ( TableName[OccassionColumnName] ), [NumberOfPallets] < 3 ) )
@Anonymous
Try this pattern
Measure = COUNTROWS ( FILTER ( VALUES ( TableName[OccassionColumnName] ), [NumberOfPallets] < 3 ) )
thanks again for this and please disregard my other response. the one question I do still have on this topic is how I would add another filter(s), based on a column (field) in the underlying table. So, combining this filter based on the outcome of a measure and one or more filters on field(s) in my table.
my trialling and errorring has not worked for me sofar.
thanks
thanks @Zubair_Muhammad for the suggestion and I'd say this would be perfect, yet countrows would overstate my outcome as there could be multiple rows per my "key". I.e. I'm grouping the number of records (product codes per delivery) per day. I'm looking for the count of the sum of this grouped sum. Using countrows would end up showing each individual row (product code) per delivery which would match the "<3" condition no?
I hope I make myself clear?
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |