Forum Discussion

Benoo876's avatar
Benoo876
Advocate I
2 years ago
Solved

Matrix formatting

I have tackled some Matrix columns settings and cannot find the solution for following two questions: 1. Is there a way to format my matrix table to add fields for Analysis_no and Method like in D...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Benoo876 

     

    You can try the following methods.

    Analysis_no Measure = CALCULATE(MAX(DATA[Analysis_no]),ALLEXCEPT(DATA,DATA[Trial],DATA[Paralel_no]))
    Method Measure = CALCULATE(MAX(DATA[Method]),ALLEXCEPT(DATA,DATA[Trial],DATA[Paralel_no]))
    Rseult = IF(HASONEVALUE(DATA[Time]),AVERAGEX(DATA,[Value]),[Analysis_no Measure]&" "&[Method Measure])


    Is this the result you expected? Please ask any questions you may have.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Benoo876 

 

You can try the following methods.

Analysis_no Measure = CALCULATE(MAX(DATA[Analysis_no]),ALLEXCEPT(DATA,DATA[Trial],DATA[Paralel_no]))
Method Measure = CALCULATE(MAX(DATA[Method]),ALLEXCEPT(DATA,DATA[Trial],DATA[Paralel_no]))
Rseult = IF(HASONEVALUE(DATA[Time]),AVERAGEX(DATA,[Value]),[Analysis_no Measure]&" "&[Method Measure])


Is this the result you expected? Please ask any questions you may have.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.