Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

vapid128's avatar
vapid128
Icon for Solution Specialist rankSolution Specialist
4 years ago

 

Measure 4 = MAXX(SUMMARIZECOLUMNS('4Table'[Item],'4Table'[Product Type],'4Table'[Vendor]),CALCULATE(SUM('4Table'[Value])))