Forum Discussion
pianotoad
4 years agoRegular Visitor
Divide two measures - wrong calculation
Hi Community, Working on my Power BI I have created two measures. One calculates all closed opportunities this year of selected user, the other calculates all won opportunities of that user this ...
- 4 years ago
Ok, my apologies. I thought after I have tried everything (I thought) I ask the community.
Now I saw there was simply another filter on my report affecting the result of the calculation, while the two measures (which I also show) are specificially not affected by that filter.
Made sure the result is also not affected by the filter and voilà, now it works correct!
pianotoad
4 years agoRegular Visitor
Ok, my apologies. I thought after I have tried everything (I thought) I ask the community.
Now I saw there was simply another filter on my report affecting the result of the calculation, while the two measures (which I also show) are specificially not affected by that filter.
Made sure the result is also not affected by the filter and voilà, now it works correct!