Trying to create a column that return true/false if the total of a project >= 10.

[ErikBI]

Hello guys,

I'm trying to create something but I can't figure out how to do this with DAX.

Basically I have a list of projects with certain amounts. Projects may be (and mostly are) in this list more than once. 

I am trying to create a column that return true or false depending in wether the amount per project is higher or lower than 10. 

See example image below:

in this example the total amount for project B and C is more than 10. These are "TRUE". project A and D are in total lower than 10, hence "FALSE".

Does anyone know how to create a dax calculated comlumn like this?

I have previously solved this solution with a sumarized table but I'd rather not stick to that solution since I don't want to add more tables to the model. 

Sincerely,

Erik

[ErikBI]

@Samarth_18 @amitchandak both of your solutions worked great. Thanks!

[Samarth_18 · Accepted solution]

Hi @ErikBI ,

You can create a column like this:-

Column = 
var result = CALCULATE(SUM('Table (6)'[amount]),FILTER('Table (6)','Table (6)'[Project ] = EARLIER('Table (6)'[Project ])))
return if(result >= 10,TRUE(),FALSE())

Output:-

Thanks,

Samarth

[amitchandak]

@ErikBI , A new column

if(sumX(filter(Table, [project] =earlier([Project]) ),[Amount]) >10, TRUE(), FALSE() )