Forum Discussion

Frequent Visitor

9 years ago

Solved

Matrix on the same column

Hi, I have 2 tables having 1 to many relationship with the ref2per table. I' am trying to get a matrix something like below: name SAP PCS EventBrite SAP 1 PCS 1 ...

Need Help

v-qiuyu-msft
9 years ago
Hi rakesh-k01,

You can create calculated columns in ref2per table like below:

Name = RELATED('ref_table'[name])

Name(update) = var t=CALCULATE(MAX('ref2per'[ref_source_system_id]),ALLEXCEPT(ref2per,'ref2per'[personal_id]))
return
IF('ref2per'[ref_source_system_id]<> t,CALCULATE(MIN('ref2per'[Name]),ALLEXCEPT(ref2per,'ref2per'[personal_id])),
CALCULATE(MAX('ref2per'[Name]),ALLEXCEPT(ref2per,'ref2per'[personal_id])))

Best Regards,
Qiuyun Yu
matrix.zip67 KB

v-qiuyu-msft

Community Support

9 years ago

Hi rakesh-k01,

You can create calculated columns in ref2per table like below:

Name = RELATED('ref_table'[name])

Name(update) = var t=CALCULATE(MAX('ref2per'[ref_source_system_id]),ALLEXCEPT(ref2per,'ref2per'[personal_id]))
return
IF('ref2per'[ref_source_system_id]<> t,CALCULATE(MIN('ref2per'[Name]),ALLEXCEPT(ref2per,'ref2per'[personal_id])),
CALCULATE(MAX('ref2per'[Name]),ALLEXCEPT(ref2per,'ref2per'[personal_id])))

Best Regards,
Qiuyun Yu

matrix.zip67 KB