Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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_])
    RETURN
    if(LOWER(USERPRINCIPALNAME()) = "lblablabvlsa" || LOWER(USERPRINCIPALNAME()) = "blblbl",total_Cost,BLANK())
     


    It worked

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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_])
RETURN
if(LOWER(USERPRINCIPALNAME()) = "lblablabvlsa" || LOWER(USERPRINCIPALNAME()) = "blblbl",total_Cost,BLANK())
 


It worked