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
hkillen's avatar
hkillen
Icon for Helper I rankHelper I
5 years ago

Therefore...could the issue be...not the Function so much as the Relationships?

I do have a lot of bi-diretional Relatoinships.  Could that be a driver?

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    hkillen Absolutely. See the thread here for example: Re: DAX Head Scratcher - Microsoft Power BI Community. It's a long thread but it shows exactly what can happen in complex data models as well as how I "fixed" it in my case. You might try a MAXX(FILTER(...),...) to see if you can get around your problem. Adding a FILTER to my CALCULATE "magically" fixed my issue so I wonder if in your case doing something similar might work. It's hard to be specific because I have no idea what your data model looks like and what columns you have in your visual.