Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculated Column to Count based on Condition

Dear All,   I am having the below table and I had created and want to have only one Calculated Column tha tells about total number of Rows for Sptin6 and total number rows in sprint5 .     Sn...
Need Help
Show and Tell
Tips and Tricks
  • Arul's avatar
    Arul
    2 years ago

    Anonymous ,

    try this

    Calculated Column = CALCULATE(
    COUNTA('Table'[Sprint]),
    ALLEXCEPT('Table','Table'[Sprint]))
Arul's avatar
Arul
Super User
2 years ago

Anonymous ,

try this

Calculated Column = CALCULATE(
    COUNTA('Table'[Sprint]),
    ALLEXCEPT('Table','Table'[Sprint]))