Matrix formatting

[Benoo876]

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 Dash example?
2. Is there a way to show average  of 3 replicates for each Trial_full and also RSD (does not have to resabmle Dash example), could be average and RSD in separate row or some other solution?

PBI:

Dash example:

Example dataset:
https://we.tl/t-v5ykEwQAPx

[Anonymous · Accepted solution]

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.

[Benoo876]

I figured out STDEV (prob can do RSD with custom measure). What is the best way to get rid off 0? I can set conditional formatting to white and white background but this also negatively affects the table design.