Forum Discussion
Matrix with only measures
Good morning everyone,
I'm trying to replicate a matrix where nor columns or rows belong to a specific table.
Example:
Day, month, m-1, year, year-1 are all measures that will calculate the number of occurrences of the events "Number of Customers in shop", "Total Sales", "Conversion Rate". The thing is, also these events are counted as measures or extracted from single columns in different tables doing some filtering.
I don't know if I made my issue clear, but what I'm used to is something more like:
Where products are listed in a column, and then the rest I calculate it in measures.
How can I display the first matrix in a single view?
EDIT: While making it dynamic, not a static view.
Thanks for your help!
Anonymous , You can make it like that. But get this you have to create a new table, which means new filter which take in this table will only work
Example
union(
summarize(Table, "Category", "On Hand > 6 months", "Quantity",[On Hand Qty > 6 Month], "Cost",[On Hand Qty > 6 usage Cost]),
summarize(Table, "Category", "On Hand <= 6 months", "Quantity",[On Hand Qty <= 6 Month], "Cost",[On Hand Qty <= 6 usage Cost])
)or
union(
summarize('QC Check 1', "'Table'","QC Check 1", "Rows",countrows('QC Check 1')),
summarize('QC Check 2', "'Table'","QC Check 2", "Rows",countrows('QC Check 2')),
summarize('QC Check 3', "'Table'","QC Check 3", "Rows",countrows('QC Check 3')) // so on
)Here I have not added any group by, means will not be filter, So add some column and join them with other dimension tables if need
1 Reply
Anonymous , You can make it like that. But get this you have to create a new table, which means new filter which take in this table will only work
Example
union(
summarize(Table, "Category", "On Hand > 6 months", "Quantity",[On Hand Qty > 6 Month], "Cost",[On Hand Qty > 6 usage Cost]),
summarize(Table, "Category", "On Hand <= 6 months", "Quantity",[On Hand Qty <= 6 Month], "Cost",[On Hand Qty <= 6 usage Cost])
)or
union(
summarize('QC Check 1', "'Table'","QC Check 1", "Rows",countrows('QC Check 1')),
summarize('QC Check 2', "'Table'","QC Check 2", "Rows",countrows('QC Check 2')),
summarize('QC Check 3', "'Table'","QC Check 3", "Rows",countrows('QC Check 3')) // so on
)Here I have not added any group by, means will not be filter, So add some column and join them with other dimension tables if need