Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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.
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.
| User | Count |
|---|---|
| 53 | |
| 40 | |
| 35 | |
| 24 | |
| 22 |
| User | Count |
|---|---|
| 136 | |
| 111 | |
| 58 | |
| 43 | |
| 38 |