cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erhan_79
Post Prodigy
Post Prodigy

Calculated Column

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 :

  •  if even one cell is " Not OTIF " under " OTIF ITEM" column , then write to all  OTIF ORDER " column for an order      "  Not OTIF "
  • if an order's all lines is  "OTIF"  under "OTIF ITEM"  column then write to to all  " OTIF ORDER " column for an order " OTIF " 

 

Capture-1.JPG 

 

Thanks in 

1 ACCEPTED SOLUTION
speedramps
Solution Sage
Solution Sage

Please consider this measure.
 
Indicator =
CALCULATE(
SELECTEDVALUE('Table'[OTIF ITEM],"No OTIF"),
ALLEXCEPT('Table','Table'[Order No])
)
 
Let's explain how this works ....
 

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 !

View solution in original post

2 REPLIES 2
erhan_79
Post Prodigy
Post Prodigy

it is ok @speedramps  , thanks

speedramps
Solution Sage
Solution Sage

Please consider this measure.
 
Indicator =
CALCULATE(
SELECTEDVALUE('Table'[OTIF ITEM],"No OTIF"),
ALLEXCEPT('Table','Table'[Order No])
)
 
Let's explain how this works ....
 

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 !

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.