Forum Discussion
holodan95
3 years agoHelper II
Show exceptions in table visual
Hello All, I'm currently facing a problem with showing only those products that have no stock, or never been to a shop. What I have: Table 'A' - A table with the products, that need to be in...
- 3 years ago
holodan95 Either https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
Or, Stock Measure = SUM('Table B'[Stock quantity]) + 0
Filter for only 0's for that measure.
Greg_Deckler
3 years agoCommunity Champion
holodan95 Either https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
Or, Stock Measure = SUM('Table B'[Stock quantity]) + 0
Filter for only 0's for that measure.
holodan95
3 years agoHelper II
Greg_DecklerThank you! I can't believe how simple the solution was.
"Stock Measure = SUM('Table B'[Stock quantity]) + 0" actually worked.
Thanks again!