Forum Discussion
Gopinath_iyer
Helper II
Helper IICalculated 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 ...
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.
Gopinath_iyerHelper II
Helper III 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.
vojtechsima
Super User
Super UserGopinath_iyer
I see, makes sense.
Here you go:
New B =
var currentGrouop = 'Table'[A]
return COUNTROWS(FILTER('Table', 'Table'[A] = currentGrouop))- Gopinath_iyer
Thanks a lot its working...but it missed the country filter...can you suggest?.
A Country B Desktop US 3 Desktop US 3 Desktop US 3 Desktop UK 1 Laptop US 1 Laptop UK 1 IPAD UK 2 IPAD UK 2 IPAD US 1