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.
Trying to use the Calculate function to filter out the orders on the SubCat2 field that have "Filler" only and do not have any other SubCat values associated with it.
I have this so far but am getting orders with Molding, Finish Panel, etc associated with that order number included.
Solved! Go to Solution.
Create a measure (you should really shorten the column names to make life a bit easier)
CountSubCat = CALCULATE(COUNT(TableJ[Sub cat]), ALLEXCEPT(TableJ, TableJ[Control ID Key]))
You then pull Control ID Key on to a table visual with the measure ( and Sub category if you need it ).
Use the visual filters pane to choose "Filler" for sub category.
If the CountSubCat is equal to 1 -> that's the winner. And there were none in the sample picture.
Hope it helps. Also can you post data rather than a picture next time. It always helps.
Create a measure (you should really shorten the column names to make life a bit easier)
CountSubCat = CALCULATE(COUNT(TableJ[Sub cat]), ALLEXCEPT(TableJ, TableJ[Control ID Key]))
You then pull Control ID Key on to a table visual with the measure ( and Sub category if you need it ).
Use the visual filters pane to choose "Filler" for sub category.
If the CountSubCat is equal to 1 -> that's the winner. And there were none in the sample picture.
Hope it helps. Also can you post data rather than a picture next time. It always helps.
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |