Reply
Member
Posts: 47
Registered: ‎01-11-2017
Accepted Solution

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


Accepted Solutions
Highlighted
Community Support Team
Posts: 3,800
Registered: ‎07-09-2016

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.

View solution in original post


All Replies
Highlighted
Community Support Team
Posts: 3,800
Registered: ‎07-09-2016

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.