Forum Discussion

hkillen's avatar
hkillen
Icon for Helper I rankHelper I
5 years ago

MAX Function disrupts Table Visaul

Hi. I created a Measure that uses the MAX function when attempting to identify  vPerentageOccupied= MAX ( [TableA] ! [PAX]) / MAX ( [TableA] ! [CAPACITY])  The Measure works just fine when the Fil...
Need Help
hkillen's avatar
hkillen
Icon for Helper I rankHelper I
5 years ago

Here is the Measure syntax:

   -------------------------------------------------------

mOTP_Head_vCapacity =
// On-Time Performance / Headstart flight /
// A/C Capacity /
// {Actual}

//-----------------------------------------

VAR vResult =
MAX (
'tdDimAircraft_smy'[cCapacity] //#####
)

RETURN
vResult
--------------------------
When I place the Measure as a Field in the Table VISUAL, the Table VISUAL spins round and round and does not update
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

hkillen I'm pretty sure I get that you are using this in a visual because nothing else makes any sense. So, next question what other tables/columns are used in that visual? Is everything coming from the tdDimAircraft_smy table or are there other tables involved? I aks because I have seen issues before in complex data models where you are trying to grab a column from another table and you end up in a situation where this generates a cartesian product of the two tables to get iterated over and that can majorly slow down visualization displays when you essentially generate a few million rows to iterate over for each and every row of the visual.