I am currently trying to find distinct combinations within a table as two of the columns have a many to many relationship with each other.
The data is all around backup policies being run on against particularly clients and could be summarized as below:
The answer I would like to generate for the above table would be 7 as there are that number of distinct combinations.
Has anyone got an idea of how this might be done? I have tried experimenting with nested counts and distinct values (where I was able to filter to one column but not both).