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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
LinthPowBI11
Regular Visitor

Hi ,why is my measure error free but its not reflecting any value?

Here's my measure 

If(
    Sheet1[Measure In/Dr] = 11,
    IF(
        AND([YTD M] < [Target M], [YTD M] < [2022 M]),
        "0",
        IF(
            AND([YTD M] >= [2022 M], [YTD M] < [Target M]),
            "1",
            IF([YTD M] >= [Target M], "2")
        )
    ),
    IF(
        Sheet1[Measure In/Dr] = 10,
        If(
            AND([YTD M] > [Target M], [YTD M] > [2022 M]),
            "3",
            IF(
                AND([YTD M] > [Target M], [YTD M] < [2022 M]),
                "4",
                IF([YTD M] < [Target M], "5")
            )
        )
    )
)

If column(In/Dr)'s value is 11 follow the first set of conditons else if  column(In/Dr)'s value is 10 , follow the next set. Measure dosent say any error but i'm not getting any value when its put under a matrix.

2 REPLIES 2
halfglassdarkly
Resolver IV
Resolver IV

If I'm reading things correctly it looks like your If statement starting on line 12 is the Value_if_true for your first if statement? If so, your formula is always going to return blank since Sheet1[Measure In/Dr] = 11 and Sheet1[Measure In/Dr] = 10 can't both evaluate to true simultaneously (and you have no value_if_false specified)

 

Hi ,thanks for the reply . The measure is working on the aggegate but not when I expand the subrows. 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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