Forum Discussion

CScottP's avatar
CScottP
Regular Visitor
1 year ago

Max Value based upon two column and content.

TYPE ACTION MODIFICATION  DATE ITEMS SPLIT_MOD   Expected    WIDGET-A   BASE 1-Dec-24 57 0   WIDGET-A 56 WIDGET-A ADD BASE 1-Dec-24 57 0   WIDGET-B 75 WIDGET-A CH...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi CScottP,

Here is the measure formula to calculate max 'ITEMS' based on current 'TYPE' and 'MODIFICATION' group and filters on the table. You can try it if helps:

formula =
CALCULATE (
    MAX ( Table1[ITEMS] ),
    ALLSELECTED ( Table1 ),
    VALUES ( Table1[TYPE] ),
    VALUES ( Table1[MODIFICATION] )
)

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

CScottP's avatar
CScottP
Regular Visitor
1 year ago

Using the example table and formula I'm only getting "100", was expecting the following.

WIDGET - A      56
WIDGET - B      75

WIDGET - C      0

TOTAL               131