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 ,
Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.