Forum Discussion
Cymbolz
7 years agoHelper III
IF statement unexpected result evaluation
I have "solved" this with a better expression, but am dumbfounded as to why. This is from a colleague, I'm unable to share the pbix without effort so hoping this is sufficient to pin-point the ca...
- 7 years ago
Cymbolz
7 years agoHelper III
Here's a clean PBIX: https://excelconsultingsolutions-my.sharepoint.com/:u:/g/personal/matt_excelconsulting_com_au/ETD-66G_A2NPmI3vgo2tr1YB8camYrglTp4kKVxZ5A65zQ?e=BRaWtu
In the matrix you'll see the measure [Opp] which is the culprit:
Opp = IF([Opportunity]>=0,[Opportunity],0)
I have used variables to create [Opp MATT] which works as expected. I'm not familiar with all the business logic and this is not my creation. Am only interested in being able to explain why the conditional test then produces what looks like a different result.
Cymbolz
7 years agoHelper III
v-jiascu-msft Any ideas? It has stumped me...
- v-jiascu-msft7 years agoMicrosoft Employee
- v-jiascu-msft7 years agoMicrosoft Employee
The report ID is CRI 111436797.
Best Regards,
- Cymbolz7 years agoHelper III
Thank you Dale. Is there a way I can see / track the progress based on this CRI ?