Forum Discussion
Countifs Function
I was able to get it. The table i created was from the following formula, then i just linked it to my existing table and created a slicer on the QuoteID and selected all except blank. Thank you for your help!
=DISTINCT(FILTER(table,table[CompanyID]=1))
I think you are on the right track of what i would like to do, and you have possibly given me another solution, but can you help me with one thing. Can i create a table of unique QuoteID's where CompanyID = 1. If i can do this, then i can link this to my other table and i wouldn't need any formulas, i would just be creating an inner join of sorts, and all the QuoteID's that do not contain Company 1 then would be removed.
I don't know what is needed to create a table, it looks like i can use a formula though.
I was able to get it. The table i created was from the following formula, then i just linked it to my existing table and created a slicer on the QuoteID and selected all except blank. Thank you for your help!
=DISTINCT(FILTER(table,table[CompanyID]=1))
Awesome! Happy to help you get to a solution!
