BKNewton29
New Member
- Joined
- Sep 17, 2010
- Messages
- 30
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]))
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]))
