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    State City Networth UP A 100 UP B 100 TN C 500 TN D 500 Kr E 102 Kr F 102 ...
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
            )
    )
)
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
            )
    )
)