Why is MAXX not working for two columns for each raw? It will break my table.

[Anonymous]

Hello, 

Can anybody please tell me why my MAX formula is not working? (It's working when I create a table with PriceElectionAmount &  HarvestPrice columns ) . I am trying to get the MAX for the two columns (PriceElectionAmount &  HarvestPrice) for each row, but when I add my measure it will keep spinning and break the whole table. 

Any Help on how to get this? Basically, I want to get the max value from PriceElectionAmount &  HarvestPrice for each row. 

I have created two measures, did not work

MAX_Price = 
    MAXX({
            max('XL-Hargrove_MpciPremLine_Data'[ PriceElectionAmount]),
            MAX(PriceKeys[ HarvestPrice])
    },
    [Value]
    )​

and this,

MAX_Price_De = 
VAR ValueTable = 
    UNION(
        ROW("Value", SUM('XL-Hargrove_MpciPremLine_Data'[ PriceElectionAmount])),
        ROW("Value", SUM(PriceKeys[ HarvestPrice]))
      )
    RETURN 
    MAXX(
        ValueTable,
        [Value]
    )

Error,

 My table looks like,

My table looks like

Thank you so much

[v-jayw-msft]

Hi @Anonymous ,

Your formulas looks fine and the error message means you don't have enough memory. 

How much RAM do you have and how big is your dataset?

Best Regards,

Jay

[Fowmy]

@Anonymous 

Your Measure should work, what was the error that you faced?

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

It just keeps spinning and give me Memory out error. 

[Fowmy]

@Anonymous 

I think you need the max of max from both the fields:

MAX_Price = 
MAX(
    MAX('XL-Hargrove_MpciPremLine_Data'[ PriceElectionAmount]),
    MAX(PriceKeys[ HarvestPrice])
)

If you need to iterate for some reason then try:

MAX_Price = 
MAXX(
    UNION(
        DISTINCT('XL-Hargrove_MpciPremLine_Data'[ PriceElectionAmount]),
        DISTINCT(PriceKeys[ HarvestPrice])
    ),
    [ PriceElectionAmount]
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

[Anonymous]

@Fowmy  surprisingly, your first formula works. Can you please tell me why my one did not load? I used MAXX. Thank you so much for the hlep. 

[Ashish_Mathur]

Hi,

Does this measure work?

=if(SUM('XL-Hargrove_MpciPremLine_Data'[ PriceElectionAmount])>SUM(PriceKeys[ HarvestPrice]),SUM('XL-Hargrove_MpciPremLine_Data'[ PriceElectionAmount]),SUM(PriceKeys[ HarvestPrice]))

[Anonymous]

@Ashish_Mathur I tried your one. It is something, just keep spinning. Thank you so much your help and time.