Forum Discussion
Solved
Use Count as a filter to exclude from database/visualization
Hello users, I have a huge database and I need to exclude all devices with a count of 1. Example: There are devices with a count of 1 and more than 1. I would like to exclude Device "1003","4001","...
danextian I used SUMMARIZE function to get count of Device IDs. Used it as a filter in my dashboard and the solution has worked.
SN_Count = SUMMARIZE('fact CEC_SR_RAW','Table'[Machine_Serial_Number],"DSN",COUNT('fTable'[Machine_Serial_Number]))
Count is not a column otherwise I would have used it as a filter. Thanks danextian
Please see my other reply.