Create a new column using DAX RRS feed

  • Question

  • Hi all

    I have the following table in Power BI:

    I need to create a custom column 'Full encryption status' with the following logic:

    1. If a computer has 1 or more not encrypted drives, the column value should be 'Not Encrypted'

    2. If all drives are encrypted, the column value should be 'Encrypted'

    3. If all drives have the encryption status 'Unknown', the column value should be 'Unknown'

    4. If a computer has a drives with the statuses 'Encrypted' and 'Unknown', the result should be 'Unknown':

    Can anyone help to create this in Power BI using DAX?

    Very appreciate your help!


    • Edited by Oleg Kyba Wednesday, February 6, 2019 8:41 PM
    Wednesday, February 6, 2019 8:40 PM