Forum Discussion
Dynamically calculate maximum cell value in matrix visualization
Hello, I am using the matrix visualization to create a matrix bubble chart using SVG, similar to this post Matrix Bubble Chart By DAX . The columns of the table are vendors, the rows are product typ...
Hi Anonymous ,
The problem I'd been having was that I would get different bubble sizes for the same value on different rows. Using ALLSELECTED('table') with no columns specified seems to accomplish what I wanted.
vapid128
Solution Specialist
Solution Specialist| Product Type | Item | Vendor A | Vendor B | Vendor C |
| clothing | shoes | 5 | 20 | |
| clothing | socks | 10 | 40 | 30 |
| groceries | apples | 15 | 25 | |
| groceries | oranges | 20 | 10 |
So the largest value in this table is 40.
measure =
MAXX(
SUMMARIZECOLUMNS(table[Product Type],table[Item],table[Vendor]),
CALCULATE([MEASURE FOR REVNUE])
)
=40
Thanks for the reply vapid128 . I tried the solution suggested, but I'm getting an error:
Error Message: MdxScript(Model) (45, 6) Calculation error in measure 'Table'[Max Revenue]: SummarizeColumns() and AddMissingItems() may not be used in this context.I should have also mentioned that, ideally, I would like to use a Fields Parameter to select the Row dimensions I want to display.
- vapid128Measure 4 = MAXX(SUMMARIZECOLUMNS('4Table'[Item],'4Table'[Product Type],'4Table'[Vendor]),CALCULATE(SUM('4Table'[Value])))