Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register 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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
65 | |
42 | |
42 |
User | Count |
---|---|
46 | |
40 | |
28 | |
27 | |
26 |