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
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.
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.
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.
