Forum Discussion
prateekraina
Memorable Member
Memorable MemberMaximum from calculated Sum
Hi Guys, Following is my dataset: Camera TimeStamp Count Cam 1 10:00 1 Cam 1 10:00 1 Cam 1 10:00 1 Cam 2 10:00 1 Cam 2 10:00 1 I have written DAX to calcu...
I have achived the desired result with below DAX:
Camera With Max People = VAR MaximumNoOfCountByCamera = MAXX(VALUES('Table'[Camera]),[Total Count]) VAR Table_SumOfCountGroupByCamera = SUMMARIZECOLUMNS(Table[Camera],"Count",SUM(Table[Count])) RETURN CALCULATE(VALUES(Table[Camera]),FILTER(Table_SumOfCountGroupByCamera,[CountofPeople] = MaximumNoOfCountByCamera))If anybody finds any other alternative, let me know :)
Prateek Raina
prateekrainaMemorable Member
Memorable MemberI have achived the desired result with below DAX:
Camera With Max People =
VAR MaximumNoOfCountByCamera = MAXX(VALUES('Table'[Camera]),[Total Count])
VAR Table_SumOfCountGroupByCamera = SUMMARIZECOLUMNS(Table[Camera],"Count",SUM(Table[Count]))
RETURN
CALCULATE(VALUES(Table[Camera]),FILTER(Table_SumOfCountGroupByCamera,[CountofPeople] = MaximumNoOfCountByCamera))
If anybody finds any other alternative, let me know :)
Prateek Raina