Forum Discussion
Distinct count for every customer row
- 5 years ago
Hi Anonymous
I've created the measure but please remember next time not to change the names of the fields in the visual as this makes it really much harder to work with the model for a person that has not worked with the model. Nobody wants to spend time on deciphering step by step, painstakingly, which field belongs to which table.
Here's the measure but I can't guarantee it'll be fast:
The Count = var vCurrentSubjectID = DISTINCT( 'D - Subject'[Subject ID] ) var vResult = if( NOT ISEMPTY( 'F - Sales packing slip' ), CALCULATE( DISTINCTCOUNT( 'F - Sales packing slip'[Packing slip ID] ), 'D - Subject'[Subject ID] in vCurrentSubjectID, ALLSELECTED( 'F - Sales packing slip' ) ) ) return vResult
Hi Anonymous
I've created the measure but please remember next time not to change the names of the fields in the visual as this makes it really much harder to work with the model for a person that has not worked with the model. Nobody wants to spend time on deciphering step by step, painstakingly, which field belongs to which table.
Here's the measure but I can't guarantee it'll be fast:
The Count =
var vCurrentSubjectID = DISTINCT( 'D - Subject'[Subject ID] )
var vResult =
if( NOT ISEMPTY( 'F - Sales packing slip' ),
CALCULATE(
DISTINCTCOUNT( 'F - Sales packing slip'[Packing slip ID] ),
'D - Subject'[Subject ID] in vCurrentSubjectID,
ALLSELECTED( 'F - Sales packing slip' )
)
)
return
vResult- Anonymous5 years agoNot applicable
Hi daxer-almighty , now it works thanks to your help. I'm very sorry to have make you lose time for the names that I've changed in the report. It was the first time for me to share a file here, but now I've understand how to do that and, most of all how to implement that formula. Thank you and have a wonderful day.