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 ,
We haven’t received a response yet and want to ensure the solution met your needs. If you need any further assistance, feel free to reach out we’d be happy to help. If everything is working as expected, kindly mark it as Accepted as solution.
Thank You.