cancel
Showing results for
Did you mean:
baronraghu Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted Community Support Team

## Re: networth calculation

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
)
)
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted Community Support Team

## Re: networth calculation

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
)
)
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.