Forum Discussion

bknewton29's avatar
bknewton29
Regular Visitor
3 years ago

SumX not working

Hi,
I'm having issues trying to get totals to appear for one of my measures. Below is the table I'm creating and I've highlighted the issue I'm having. Below that is the meaures I've created. Any help would be appreciated.

 

Lost Check 1 = ([FX Renewable Income (CY)]=0 && [FX Renewable Premium (CY)]=0 && [FX Renewable Income (PY)]>0)*1

Lost Check 2 = ([FX Renewable Income (CY)]<>0 && [FX Renewable Premium (CY)]<>0 && [FX Renewable Income (PY)]=0)*1

Overall Lost Check = [LostCheck1]+[LostCheck2]

Lost Calc = [FX Retained Income (Renewal)]-[FX Retained Income 1 Year Ago]-[Non-recurring business]

Lost Value = ([Lost Overall Check]>0)*[LostCalc]

Attempt at Lost measure =

IF(HASONEFILTER('Acturis Transaction Data'[ContRef|CommProd])=TRUE(),
[LostValue],
SUMX(SUMMARIZE('Acturis Transaction Data','Acturis Transaction Data'[ContRef|CommProd]),[LostValue]))

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi bknewton29 ,

     

    The table you created with SUMMARIZE does not have [LostValue] column, you try modifying it as:

    Attempt at Lost measure =
IF (
    HASONEFILTER ( 'Acturis Transaction Data'[ContRef|CommProd] ) = TRUE (),
    [LostValue],
    SUMX (
        SUMMARIZE (
            'Acturis Transaction Data',
            'Acturis Transaction Data'[ContRef|CommProd],
            "Value", [LostValue]
        ),
        [Value]
    )
)

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.