Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there ;
İ need your help about below issue ;
on the below chart i have two order number and have 3 lines with details .I want to create a column whic one's name is "OTIF ORDER" and colour is yellow
Formula rule will be :
Thanks in
Solved! Go to Solution.
The default row context is Order no, item No and OTIF ITEM
CALCULATE overrides the default row context with ALLEXCEPT Order no.
This drops the Item No and OTIF ITEM default row filters and will process all the rows for the Order no.
The SELECTEDVALUE will return OTIF ITEM value is there is just one value for the Order no.,
otherwise it will return “No OTIF”.
Hope you understand my explanation.
Remember we are BI community volunteers so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works. Thank you !
The default row context is Order no, item No and OTIF ITEM
CALCULATE overrides the default row context with ALLEXCEPT Order no.
This drops the Item No and OTIF ITEM default row filters and will process all the rows for the Order no.
The SELECTEDVALUE will return OTIF ITEM value is there is just one value for the Order no.,
otherwise it will return “No OTIF”.
Hope you understand my explanation.
Remember we are BI community volunteers so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works. Thank you !
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |