Only display unique value

Casperserven1 — Thu, 22 Jun 2023 15:16:39 GMT

Here is an interesting conumdrum. In this data here we have some Employees who have achieved various skill levels against various skill types. The Skill types are not included here. What we are trying to do is count the number of staff at their highest level but no at any other level.

So the count for this data would be

Level 4 = 1 (only Fred - his highest level))

Level 3 = 2 (George & Henry - their highest level

Level 2 = 0 (George, Henry and Fred already counted at the highest level)

Level 1 = 0 ((George, Henry and Fred already counted at the highest level).

Any ideas of what the calculation would look like?? - trying for a funnel chart

Name	Level
Fred	4
Fred	2
Fred	3
George	3
George	2
George	1
Henry	1
Henry	2
Henry	3

Re: Only display unique value

Casperserven1 — Thu, 22 Jun 2023 16:09:35 GMT

...and worked out my own solution create a table using summarize:

test = SUMMARIZE (Data2, Data2[Name], Data2[Date], "maxrate", MAX(Data2[Level]))

topic Re: Only display unique value in DAX Commands and Tips

Only display unique value

Re: Only display unique value