cancel
Showing results 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.

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
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)

Regular Visitor

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

Announcements

#### 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

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors