Forum Discussion

cdnjj's avatar
cdnjj
Frequent Visitor
8 years ago
Solved

COUNTX distinct values without CALCULATE

Hello,   Any thoughts on how to convert the statement below into a distinct count?    Here's the trick; it needs to be accomplished without using CALCULATE (due to a circular reference limitation)....
Need Help
  • cdnjj's avatar
    cdnjj
    8 years ago

    Magic!  Corerct, I am building out a calculated column.  

     

    Thank you.  

     

     

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
8 years ago

Hey,

 

It would be really helpful if you would provide sample data.

 

But my first idea would be

 

COUNTROWS(
  VALUES(SalesLineData[TransactionNumber])
)

Hope this helps

 

Regards

Tom