Forum Discussion
Calculated column
Hello Friends,
Can you help me with the below calculation,
I want to create a new column "B" based on existing column "A".
| A | B |
| Desktop | 4 |
| Desktop | 4 |
| Desktop | 4 |
| Desktop | 4 |
| Laptop | 2 |
| Laptop | 2 |
| IPAD | 3 |
| IPAD | 3 |
| IPAD | 3 |
Hi Gopinath_iyer ,
It seems that you want to calculate the row count of each A and each Country, right?
Please try:
B = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[A],'Table'[Country]))Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi, Gopinath_iyer
Can you be more precise about what exactly you want?
Do you want just a duplicate of the A column?
You can do that by just referencing the column in Calculated Column like this:B = 'Table'[A]I want to create column B with count of attributes in column A respectively.
E.g Column A has 4 rows with "Desktop" so column B should 4 and
Column A has 2 rows for "Laptop" so B should be 2 and so on.
Gopinath_iyer
I see, makes sense.
Here you go:New B = var currentGrouop = 'Table'[A] return COUNTROWS(FILTER('Table', 'Table'[A] = currentGrouop))
Hi Gopinath_iyer ,
It seems that you want to calculate the row count of each A and each Country, right?
Please try:
B = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[A],'Table'[Country]))Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
