topic Re: Measure to return maximum text for duplicate data in DAX Commands and Tips

Measure to return maximum text for duplicate data

SAP4026 — Sun, 07 May 2023 15:30:13 GMT

Hi,

New BI user.

From the sample below, I want to have a measure that results in the last Teacher’s Name that Jane Doe has a class with (final measure should result in Teacher Smith). How do I do that?

Student ID	Student Name	Teacher’s Name	Subject Period
001	Jane Doe	Teacher Smith	7th
001	Jane Doe	Teacher Johnson	5th
001	Jane Doe	Teacher Pearl	1st

Thanks.

Re: Measure to return maximum text for duplicate data

tamerj1 — Sun, 07 May 2023 16:47:42 GMT

Hi SAP4026

please try

Last Teacher's Name =
MAXX (
TOPN (
1,
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Student ID] ) ),
'Table'[Subject Period]
),
'Table'[Teacher's Name]
)

Re: Measure to return maximum text for duplicate data

SAP4026 — Sun, 07 May 2023 23:13:00 GMT

tamerj1 thank YOU!!!