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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

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
Responsive Resident
Responsive Resident

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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