topic Re: Counting Specific ClaimSeriesNumber if there is multiple entry in DAX Commands and Tips

Counting Specific ClaimSeriesNumber if there is multiple entry

Boopep — Wed, 27 Aug 2025 12:42:08 GMT

Asking for a DAX command to count only the ClaimSeriesNumber that is if there is a duplicate ClaimSeriesNumber count only the one with the latest DateReceived.

Re: Counting Specific ClaimSeriesNumber if there is multiple entry

rohit1991 — Wed, 27 Aug 2025 13:04:48 GMT

Hi Boopep

Could you please try this measure:

Count Latest ClaimSeries = VAR LatestRows = FILTER ( ALLSELECTED ( 'Claims' ), NOT ISBLANK ( 'Claims'[DateReceived] ) && 'Claims'[DateReceived] = CALCULATE ( MAX ( 'Claims'[DateReceived] ), ALLEXCEPT ( 'Claims', 'Claims'[ClaimSeriesNumber] ) ) ) RETURN COUNTROWS ( SUMMARIZE ( LatestRows, 'Claims'[ClaimSeriesNumber] ) )

Re: Counting Specific ClaimSeriesNumber if there is multiple entry

MasonMA — Wed, 27 Aug 2025 14:44:29 GMT

Hello Boopep

If you only want a count of distinct ClaimSeriesNum considering their latest DateReceived (no need to see other columns) and if duplicates with the same latest date don’t matter,

COUNTROWS ( SUMMARIZE ( table, table[ClaimSeriesNum], "LatestDate", MAX ( table[DateReceived] ) ) )

Re: Counting Specific ClaimSeriesNumber if there is multiple entry

Boopep — Wed, 27 Aug 2025 14:42:06 GMT

Thank you on this

Re: Counting Specific ClaimSeriesNumber if there is multiple entry

MasonMA — Wed, 27 Aug 2025 14:43:39 GMT

Happy to see it works:)

Re: Counting Specific ClaimSeriesNumber if there is multiple entry

Boopep — Wed, 27 Aug 2025 15:00:11 GMT

Thank you.... i tested it it correct.... how about if i want to display only the total CLAIMSAMOUNT of those "LatestDate" in a Card. What would be the DAX measure

Re: Counting Specific ClaimSeriesNumber if there is multiple entry

MasonMA — Wed, 27 Aug 2025 15:18:00 GMT

This isnt as intuitive as your original request. I'd suggest opening another post with your data pasted in your message in a right format (not images) so that other users can test in their pbi desktop and give your a correct solution:)