Forum Discussion

mm5308's avatar
mm5308
Helper I
4 years ago
Solved

Reference a Column Resulting from a Summarize Function, Within the Same Table Function??

Tried searching for this topic for a while but honestly I'm not even sure how to word what I'm trying to accomplish, so I'll explain it.   My main table contains a couple dozen columns and I'm tryi...
Need Help
  • davehus's avatar
    davehus
    4 years ago

    Hi mm5308 ,

     

    Try this column measure to see if it gets you the desired outcome.

     

    Count Batches = CALCULATE(COUNTA('Table'[BatchID]),ALLEXCEPT('Table','Table'[BatchID]))
     

     

     

     

mm5308's avatar
mm5308
Helper I
4 years ago

Yes, that worked perfectly! Thank you davehus! Now I need to learn more about ALLEXCEPT...

davehus's avatar
davehus
Memorable Member
4 years ago

No problem, every day is a school day with PowerBI. 🙂