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.
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])))
I also noted that this case is simillar to me but works :(
https://community.powerbi.com/t5/Desktop/Filter-only-highest-value-by-category/m-p/118551#M50044
Any hhelp will be greatly appreciated.