Forum Discussion
table not summing
Hi, this is probably something simple... but I can't get it to work... I created a measure to get the cost. For some reason it is not summarizing correctly. This is the Measure Cost2 = var tota...
I solved this at the end... I neede to use the USERPRINCIPAL() function so thats why I needed a measure.
At the ned I created a column field with the above logic and then created a measure referencing the column and using the userprincipla().Below the code I used to reference the column with above logic and added the userprincipal.
Cost =var total_Cost = SUM(Task[Cost_])RETURNif(LOWER(USERPRINCIPALNAME()) = "lblablabvlsa" || LOWER(USERPRINCIPALNAME()) = "blblbl",total_Cost,BLANK())
It worked
Hi Anonymous
I remember Tutu_in_YYC fixed a similar issue , check if this helps you ?
https://community.fabric.microsoft.com/t5/Desktop/summing-time-utilization/td-p/4615038
Yup similar issue. Especially Anonymous is using switch statement in the result.
The reason why it is returning 4097, is probably because its returning only one of the cases in the switch statement instead of summing it.
