Forum Discussion
Solved
How to filter for unique values
Hi everyone! I have a data set that looks like this: Name Method Test1 Low Test2 Low Test3 High Test1 High I would like to filter the powerbi visual to only hav...
I was able to figure out the solution!
I just had to make a calculated column with the following equation:
Exists in Low =var _low = SELECTCOLUMNS(filter(Table, 'Table'[Method] = "Low"), "Name", [Name])returnIF( 'Table'[Name] in _low, "Not Unique", "Unique")This returned a column that listed whether each Named entry was included in the low method. I filtered the page on method = high and exists in low = unique. This gave me what I was looking for, unique values that were not contained in the low method and just the high method.
I was able to figure out the solution!
I just had to make a calculated column with the following equation:
Exists in Low =
var _low = SELECTCOLUMNS(filter(Table, 'Table'[Method] = "Low"), "Name", [Name])
return
IF( 'Table'[Name] in _low, "Not Unique", "Unique")
This returned a column that listed whether each Named entry was included in the low method. I filtered the page on method = high and exists in low = unique. This gave me what I was looking for, unique values that were not contained in the low method and just the high method.