How to find the corresponding median "PMO no." that the median value was extracted from

[ephramz]

Need help with median measure

10m ago

I have this matrix table that contains
Rows: 

1) Op. No.

2) Order

Columns:
Equipment

Values:
[Total Act Time per pcs] Measure


I have this measure named Median:

MEDIANX(filter(SUMMARIZE('ENGG VW_TRM','ENGG VW_TRM'[Op. No.],'ENGG VW_TRM'[Equipment],"_1",[Total Act Time per pcs]), [_1]<>0),[_1])

which gives me the median values of the Total Act Time per pcs for each under each Op. No. which contains respective Order No.

How can I create a measure to find the median Order No.
If lets say there is an odd number of Orders with Total Act Time per pcs, return 1 Order number

If there is an even number of Orders with Total Act Time per pcs, return 2 Order number

[ephramz]

I have this matrix table that contains
Rows: 

1) Op. No.

2) Order

Columns:
Equipment

Values:
[Total Act Time per pcs] Measure


I have this measure named Median:

MEDIANX(filter(SUMMARIZE('ENGG VW_TRM','ENGG VW_TRM'[Op. No.],'ENGG VW_TRM'[Equipment],"_1",[Total Act Time per pcs]), [_1]<>0),[_1])

which gives me the median values of the Total Act Time per pcs for each under each Op. No. which contains respective Order No.

How can I create a measure to find the median Order No.
If lets say there is an odd number of Orders with Total Act Time per pcs, return 1 Order number

If there is an even number of Orders with Total Act Time per pcs, return 2 Order number

[v-yingjl]

Hi @ephramz ,

Not certain what is your expected output based on your description, some questions wants to know:

1. What does odd/even number of Orders mean, the count or else?
2. What will the output return or what doed 1/2 Order number represent?

Perhaps you can consider sharing more details or a sample table about this case.

Sample data and expected output would help tremendously.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.