John Yip on 06 Dec 2021 03:51:13
I have some data in which the filtering conditions are based on a measure (RANKX).
I managed to do some workarounds to make the filtering happen and present them in a matrix.
However, I cannot plot the data in that matrix using other kind of visualizations, because the filtering measure (RANKX) will calculate wrongly.
I plot the data using SUMMARIZECOLUMNS() but the problem is SUMMARIZECOLUMNS() returns a static table and that the filtering measure (RANKX) is meant to be configurable by users.
Would be appreciated if there is a way to plot visualizations based on data in a matrix. The way I can think of is to allow users to store the matrix in a variable, or allows a dynamic summarized table.