Forum Discussion
Proper Filtering Context for Distinctcounts
Hello, I have a table with a handful of columns that offer information about the transactional history of a case. The Case Number, the Time of Entry into Queue and AssignTime are the primary colu...
Anonymous
Here is a simple measure that should do what you want:
Cases Never Assigned = COUNTROWS ( FILTER ( VALUES ( YourTable[Case Number] ), ISBLANK ( CALCULATE ( MAX ( YourTable[AssignTime] ) ) ) ) )The measure counts the number of Case Numbers where the maximum AssignTime is blank, indicating that there is no AssignTime.
You could possibly do something with SELECTEDVALUE but I think this measure is good enough.
Regards,
Owen
Hi,
Drag Case Number to the visual and write the following measure
=if(COUNTBLANK(Data[AssignTime])=COUNTROWS(Data),1,BLANK())
Hope this helps.
Thank you Ashish.
You are welcome. If my reply helped, please mark it as Answer.