cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
baronraghu Member
Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: networth calculation

@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
            )
    )
)
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.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: networth calculation

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