Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating Conditional Measurements

I have a simple measure that is as follows:   AVG QTY PRODUCED = COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 5 DAY])   What I need to accomplish is to make this measure conditio...
  • camargos88's avatar
    camargos88
    6 years ago

    Anonymous ,

     

    Have you tried hard code on it?

     

    AVG QTY PRODUCED =

    VAR _site = SELECTEDVALUE(TABLE[SITE])

    RETURN

    IF _site = 21201;

    COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 4 DAY]);

    AVG QTY PRODUCED = COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 5 DAY]))

     

    Did I answer your question? Mark my post as a solution!
    Ricardo

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    camargos88 

     

    That's a good idea.  This is what worked.

     

    AVG QTY PRODUCED =
    VAR _site = SELECTEDVALUE('SHIPMENTS OUT'[SITE])
    RETURN
    IF(_site = 21201,
    COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 4 DAY]),
    COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 5 DAY]))
camargos88's avatar
camargos88
Community Champion
6 years ago

Anonymous ,

 

Have you tried hard code on it?

 

AVG QTY PRODUCED =

VAR _site = SELECTEDVALUE(TABLE[SITE])

RETURN

IF _site = 21201;

COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 4 DAY]);

AVG QTY PRODUCED = COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 5 DAY]))

 

Did I answer your question? Mark my post as a solution!
Ricardo

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    camargos88 

     

    That's a good idea.  This is what worked.

     

    AVG QTY PRODUCED =
    VAR _site = SELECTEDVALUE('SHIPMENTS OUT'[SITE])
    RETURN
    IF(_site = 21201,
    COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 4 DAY]),
    COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 5 DAY]))