Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculate Min/Max and Count for each row

How to get a visual showing the MIN and MAX areas for each Apartment Code entry from the data in a table such as the one below?   Also, how do I format the %GT Area Apartment Code Total to show w/o...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Use the format area on the Modeling tab to decrease the number of decimal places to 0. Hit the up arrow because it is probably set to Auto at the moment.

     

    I believe that the two measures that you want are:

     

    MIN Area = MIN(Table[Area])

MAX Area = SUM(Table[Area])

    If you put those in a table along with your [Apartment Code] you should get what you want.

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Anonymous

 

In your scenario, you want to calculate the MAX or MIN areas for each Apartment Code group. Right?

 

To achieve your requirement, you can create calculated column with expression like:

 

Min Area =
CALCULATE (
    MIN ( 'Apartment Table'[Area] ),
    FILTER (
        'Apartment Table',
        'Apartment Table'[Apartment Code]
            = EARLIER ( 'Apartment Table'[Apartment Code] )
    )
)
MAX Area =
CALCULATE (
    MAX ( 'Apartment Table'[Area] ),
    FILTER (
        'Apartment Table',
        'Apartment Table'[Apartment Code]
            = EARLIER ( 'Apartment Table'[Apartment Code] )
    )
)

The result shows like this:

 

Thanks,
Xi Jin.