Forum Discussion
hkillen
Helper I
Helper IMAX 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...
hkillenHelper I
Helper ITherefore...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
Community Champion
Community Championhkillen 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.