Forum Discussion

baronraghu's avatar
baronraghu
Helper III
8 years ago
Solved

networth calculation

HI All,

 

I have a query and hope you could help me out

 

I have Following table 

 

StateCityNetworth
UPA100
UPB100
TNC500
TND500
KrE102
KrF102
KrG102
KrH102
RjI250
RjJ250
RjK250

 

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

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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
            )
    )
)

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    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
            )
    )
)