Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

DAX query to return CompI have liant or Non Compliant based on the filter

ausafonly_0-1684672982571.png

Based on this data I want to create a calculated column or measure.

If compliance_status is both installed and required result should be Non compliant otherwise compliant in a new column.

I have no idea how to achieve it tried multiple ways but no luck.

Any suggestion how to achieve it.

3 REPLIES 3
Mrxiang
Helper II
Helper II

You can use the DAX language to create a computed column or metric to implement your requirements. Here is a sample DAX formula:

Compliance Status = IF(Table1[Compliance_Status] = "Installed" && Table1[Compliance_Status] = "Required",  "Non compliant", "Compliant")

This formula checks whether the value in the Compliance_Status column contains both "Installed" and "Required". If so, the result is "Non compliant", otherwise it is "Compliant". You can apply this formula to a new computed column or measure to display the results in a table.
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

You can try to use the following measure formula to get the correspond statues count based on current hostname:

formula =
VAR currName =
    SELECTEDVALUE ( Table[HostName] )
VAR summary =
    SUMMARIZE (
        FILTER (
            ALLSELECTED ( Table ),
            [compliance_status] IN { "Installed", "Required" }
        ),
        [HostName],
        [compliance_status]
    )
RETURN
    IF (
        COUNTROWS ( FILTER ( summary, [HostName] = currName ) ) < 2,
        "Compliant",
        "Non compliant"
    )

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Unfortunately it didn't worked as expected.

However I tried another method and it worked.

I have created a duplicate table and then used group by to achieve the solution.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Users online (529)