DAX based on 3 columns

[Anonymous]

Hi,

I want to create a measure and use it as a slicer.

Here is my table.

My measure should be in the name of "NotListed". It should be give the values which Available_Status = Available and Active_Status ="Blank" and Not Active_Status="Blank".

Thanks !

[selimovd · Accepted solution]

Hey @Anonymous ,

you cannot use a measure as a slicer, but you can use a calclated column as a slicer.

Add a calculated column:

NotListed = If(myTable[Available_Status]="Available" &&  myTable[Active_Status]="" && myTable[Not Active_Status] <> "" , "NotListed", "Listed")

If your string is really blank and not just an empty string use the BLANK() function to check against.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up.

Best regards
Denis

Blog: WhatTheFact.bi