MAX Function disrupts Table Visaul

Question

Hi.I created a Measure that uses the MAX function when attempting to identify&nbsp;vPerentageOccupied= MAX ( [TableA] ! [PAX]) /&nbsp;MAX ( [TableA] ! [CAPACITY])&nbsp;The Measure works just fine when the Filter Context is isolated to one ID value.However, when adding the Measure to a Table Visual...a Table Visual with thousands OF ID values....the Table Visaul will not update...just spins round, and round, and round....Can I use the MAX function in a Table Visual?&nbsp; Should I use a different Function to accomplish the same task.I understand I can create a Calculated Column in [TableA], but I believe Measures are more efficient.&nbsp;Your thoughts?&nbsp;Simple Example, for demonstation purposes.TableA[ID]&nbsp; [PAX] [CAPACITY]1&nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; 2002&nbsp; &nbsp; &nbsp; &nbsp;150&nbsp; &nbsp; &nbsp;2003&nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp;2004&nbsp; &nbsp; &nbsp; &nbsp;175&nbsp; &nbsp; 200

greg_deckler · Answer

hkillen&nbsp;What is that syntax? I tried that syntax and that did not work at all. Should be:
vPerentageOccupied= MAX ( 'TableA'[PAX]) / MAX ( 'TableA'[CAPACITY]) 
I don't see why that wouldn't work in a table where ID is included.&nbsp;
I tried with this table:
Table = 
    ADDCOLUMNS(
        GENERATESERIES(1,10000),
        "PAX",RANDBETWEEN(0,175),
        "CAPACITY",200
    )
and a visual that included an unsummarized [Value] and the measure and got subsecond response time.

hkillen · Answer

I'm referring to a Table Visual (i.e., Card, MultiCard, Matrix, Table)...not a Data Table imported or a Table created from DAX.

hkillen · Answer

I am trying to use a MEASURE in a Table Visual.The Measure includes the MAX function, to isolate the ID from the Data Table (TableA)

greg_deckler · Answer

hkillen&nbsp;? I don't know what you mean by that. I have never seen that syntax in DAX or the ability to refer to a visualization in DAX so no idea what you mean.

hkillen · Answer

I have a Table VISUAL...that'd I'd like to populate with Columns and Measures.The Table VISUAL has displayed every ID.I have no challenges adding Column (i.e. Fields) to the Table VISUAL.A couple of Measures I'm attempting to add...I am having challenges.&nbsp; The common denominator I have identified in the Measures is, perhaps, use of the MAX() Function.&nbsp; Is there a different function I can used that will provide the values from an imported DATA table that align with the unique ID indicated in the VISUAL table?

Forum Discussion

MAX Function disrupts Table Visaul

10 Replies

Related content

DATESYTD function

function behavior

DAX Studio space after function name

function enable staging

Rank Function