Forum Discussion
Create a conditional column by summarizing the unique values in the source table
| Entity ID | Entity Name | Account No. | Account Name | Amount |
| 100 | Entity A | 1001 | Name 1 | 1000 |
| 100 | Entity A | 1002 | Name 2 | 2000 |
| 101 | Entity B | 1004 | Name 4 | 2500 |
| 101 | Entity B | 1005 | Name 5 | 3000 |
| 102 | Entity C | 1008 | Name 8 | 1800 |
| 102 | Entity C | 1009 | Name 9 | 4000 |
I have a data in a table format as above where there are multiple entities with multiple account nos and names now i want to create a new column by summarizing the amount based on entity id and have a condition as following : If(Amount >= Total Assets, "Entire", "No") the total assets is present in a different table as single record
Hi pranays1 ,
I created some data:
Here are the steps you can follow：
1. Create calculated column.
Condition = var _sum= SUMX( FILTER(ALL('Total Assets Table'), 'Total Assets Table'[Entity ID]=EARLIER('Table'[Entity ID])),[Total Assets]) return IF( [Amount]>=_sum,"Entire", "No")2. Result:
If it doesn't meet your expectations, you can provide more information about "total assets" and we can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi pranays1 ,
I created some data:
Here are the steps you can follow：
1. Create calculated column.
Condition = var _sum= SUMX( FILTER(ALL('Total Assets Table'), 'Total Assets Table'[Entity ID]=EARLIER('Table'[Entity ID])),[Total Assets]) return IF( [Amount]>=_sum,"Entire", "No")2. Result:
If it doesn't meet your expectations, you can provide more information about "total assets" and we can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly