Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |