Forum Discussion
Solved
Create filtered table based on max value
Hi, have been using Power BI for a while and I'm trying to get better in DAX I have a problem that I'm trying to solve for months ( have a working solution in power query but the query update is ...
I am a bit short of time to test this.
Can you use this and test it please?
TableX = VAR _tab = ADDCOLUMNS(TableY, "MaxTot", CALCULATE(MAX(TableY[TOTAL]), ALLEXCEPT(TableY, TableY[Emp], TableY[Data], TableY[Numero]))) RETURN FILTER(_tab, TableY[TOTAL] = [MaxTot])
