Forum Discussion
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)....
Magic! Corerct, I am building out a calculated column.
Thank you.
cdnjj, do you want to create a calculated column?
If yes, here is what you can try:
Customer Transaction Count =
COUNTROWS (
GROUPBY (
FILTER (
SalesLineData,
DailySalesSummary[Date] = SalesLineData[Date]
),
SalesLineData[TransactionNumber]
)
)Magic! Corerct, I am building out a calculated column.
Thank you.