Please can I know why my max by group by is not working?
I reffered to various threads in here and they have done the same , but doesn't work for me.
I need to find the maximum of 'Changed date' by employee, but it returns the maxium for the table.
Go to Solution.
I just opened a new power BI and connected, my intial formula works!
Thanks amit for your time and suggestions.
View solution in original post
You are using on the same table that is causing an issue. Ref -https://docs.microsoft.com/en-us/dax/allexcept-function-dax
Try using employee from the employee dim
Thanks, but I don't have a dimesion table.
Is it possible to find the maximum within the same table?
Ref this. Seems like same case
I am a newbie to power BI and DAX, couldn't understand where the test107measure column/measure came from in the formula ?
Test107 = CALCULATE(SUM(Test107Measure[Sales]),FILTER(ALL(Test107Measure),Test107Measure[Client]=SELECTEDVALUE(Test107Measure[Client])))
I also noted that this case is simillar to me but works 😞
Any hhelp will be greatly appreciated.
Should be something like this in your case
Max Employee = CALCULATE(max(sheet1[change Date]),FILTER(ALL(sheet1),sheet1[employee]=SELECTEDVALUE(sheet1[employee])))
So it might work as a measure
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!