Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
77 | |
76 | |
41 | |
29 | |
24 |
User | Count |
---|---|
96 | |
91 | |
52 | |
47 | |
46 |