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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

hkillen 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. 

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

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

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

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

      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.  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's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        5 years ago

        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