Forum Discussion

GyMpX's avatar
GyMpX
Frequent Visitor
3 years ago
Solved

Group and Subgroup MAXX function calculate table

Hello everybody! I need some help please: I have a table with a few columns and I want to make a mesure with the sum of 2 columns, and the maximum of one of them. All this need to be filter by the ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi GyMpX ,

     

    We can create measures in new table [Filtre Date].

     

    Nb1 =

SUM(Fichiers[nombre])
    MAX NB Zone1 = 

var _table=SUMMARIZE(ALLSelected('Fichiers'),Fichiers[zone],'Fichiers'[Produit],"Nb",[Nb1])

return

MAXX(FILTER(_table,[zone]=MAX('Fichiers'[zone])),[Nb])

     

    Then the result is as follows.

     

    Best Regards,

    Neeko Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

GyMpX's avatar
GyMpX
Frequent Visitor
3 years ago

Thank you a lot for your answer!

But i have always a problem if i want to add a filter on the date (which is present in my first table). I prefer create a measure. and I think A little thing miss in my request.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi GyMpX ,

 

We can create measures in new table [Filtre Date].

 

Nb1 =

SUM(Fichiers[nombre])
MAX NB Zone1 = 

var _table=SUMMARIZE(ALLSelected('Fichiers'),Fichiers[zone],'Fichiers'[Produit],"Nb",[Nb1])

return

MAXX(FILTER(_table,[zone]=MAX('Fichiers'[zone])),[Nb])

 

Then the result is as follows.

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.