Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 calculate the sum grouped by camera:
Total Count= SUM(Table[Count])
And i get following result in a table:
Camera | Total Count |
Cam 1 | 3 |
Cam 2 | 2 |
Problem Statement:
The issue which i am facing is to get the camera which has highest count associated to it. In this case, it is Cam 1.
I have tried below DAX expression to get the Camera but it is not yielding the desired result.
CALCULATE(VALUES(Table[Camera]),FILTER(Table,Table[Count] = MAX(Table[Count])))
Kindly help.
Prateek Raina
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |