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
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
107 | |
96 | |
92 | |
87 | |
69 |
User | Count |
---|---|
165 | |
130 | |
129 | |
102 | |
98 |