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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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