networth calculation

[baronraghu]

HI All,

I have a query and hope you could help me out

I have Following table 

State	City	Networth
UP	A	100
UP	B	100
TN	C	500
TN	D	500
Kr	E	102
Kr	F	102
Kr	G	102
Kr	H	102
Rj	I	250
Rj	J	250
Rj	K	250

To calculate the networth the methodology to be used is if on slicer I select a two or more state then the networth will be the max of the states selected+20% of the other state.

Example if on Slicer I selected UP and TN then the total networth will be= 500+100*0.2= 520

Please note the networth is calculated at state level hence the duplicate data must be ignored

[v-chuncz-msft · Accepted solution]

@baronraghu,

You may add the following measure.

Measure =
SUMX (
    VALUES ( Table1[State] ),
    CALCULATE (
        MAX ( Table1[Networth] )
            * IF (
                RANKX ( ALLSELECTED ( Table1[State] ), CALCULATE ( MAX ( Table1[Networth] ) ) )
                    = 1,
                1,
                0.2
            )
    )
)