Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum exclude blanks

Hi all,   I'm trying to figure out a way to make this work;   Every day a person works he will have to do multiple calls. On each call the employee is promoted to choose if it's the first visit o...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , try like

    sumx(filter(summarize(Table, Table[Date & Time].Date, Table[User], "_1" ,sumx(Table, Table[Begin odometer]-Table[End odometer gain])),[_1]>0),[_1])

     

    Group at day and user level and then check >0

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , try like

sumx(filter(summarize(Table, Table[Date & Time].Date, Table[User], "_1" ,sumx(Table, Table[Begin odometer]-Table[End odometer gain])),[_1]>0),[_1])

 

Group at day and user level and then check >0

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Amit,

 

Thanks, i got it working using this formula:

 

 

KmVertrek minus KmAankomst = 
sumx(filter(summarize('datalake calls', 'datalake calls'[ActualStart].[Date], 'datalake calls'[UserId], "_1" ,sumx('datalake answers', 'datalake answers'[KmAankomst] - 'datalake answers'[KmVertrek])),[_1]>0),[_1])