Forum Discussion
Solved
Max by group by not working
Hi All, 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...
I just opened a new power BI and connected, my intial formula works!
max date = CALCULATE(MAX(Sheet1[changed date]),ALLEXCEPT(Sheet1,Sheet1[employee]))Thanks amit for your time and suggestions.
amitchandak
Super User
Super UserRef this. Seems like same case
https://community.powerbi.com/t5/Desktop/Calculate-subtotal-using-dax/td-p/564402
Hi,
I am a newbie to power BI and DAX, couldn't understand where the test107measure column/measure came from in the formula ?
@ https://community.powerbi.com/t5/Desktop/Calculate-subtotal-using-dax/td-p/564402
Test107 = CALCULATE(SUM(Test107Measure[Sales]),FILTER(ALL(Test107Measure),Test107Measure[Client]=SELECTEDVALUE(Test107Measure[Client])))