Forum Discussion
Helper IMAX Function disrupts Table Visaul
Community Championhkillen ? 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.
Helper II 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. The common denominator I have identified in the Measures is, perhaps, use of the MAX() Function. 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?
- Greg_Deckler
hkillen You could use MIN or LOOKUPVALUE maybe but what is your actual DAX code because I can be fairly certain that:
vPerentageOccupied= MAX ( [TableA] ! [PAX]) / MAX ( [TableA] ! [CAPACITY])
is not it. MAX is not a function that normally causes issues in DAX formulas. So, I have to believe that the issue you are facing is something else entirely. As my test indicated, I had a table of 10,000 unique ID's and a DAX formula with proper syntax returns in less than a second. So there is something else going on and in order to help you I need your actual DAX formula.
I understand from your capitalizations that you are annoyed and don't think I understand how visuals work. I ask you, how exactly else are you supposed to use a measure or column exactly? Of course you are using it in a VISUAL. I can assure you that I am not mystified by how you are using measures and columns, I am mystified by your syntax.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490- hkillen
Here is the Measure syntax:
-------------------------------------------------------
mOTP_Head_vCapacity =// On-Time Performance / Headstart flight /// A/C Capacity /// {Actual}//-----------------------------------------VAR vResult =MAX ('tdDimAircraft_smy'[cCapacity] //#####)RETURNvResult--------------------------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
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.