Forum Discussion
Cymbolz
Helper III
7 years agoIF 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
Helper III
7 years agoHere'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
Helper III
7 years agov-jiascu-msft Any ideas? It has stumped me...
- v-jiascu-msft7 years ago
Microsoft Employee
- v-jiascu-msft7 years ago
Microsoft Employee
The report ID is CRI 111436797.
Best Regards,
- Cymbolz7 years ago
Helper III
Thank you Dale. Is there a way I can see / track the progress based on this CRI ?