SumX not working

[bknewton29]

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]))

[Anonymous]

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.