Forum Discussion

Lowspin's avatar
Lowspin
New Member
4 years ago
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...
Need Help
  • Lowspin's avatar
    Lowspin
    4 years ago

    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.
parry2k's avatar
parry2k
Super User
4 years ago

Lowspin is this what you are looking for?

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Lowspin's avatar
Lowspin
New Member
4 years ago

No the slicer doesn't fix my problem. Because it doesn't fix my first condition (Values that have a high and low value for method are not excluded).