Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Helper II
4 years ago
Solved

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

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.