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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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