Forum Discussion

mrbajana's avatar
mrbajana
Helper III
2 years ago
Solved

Sum Ranking Mesure

I have this formula for Ranking by Product Type(Cervezas,Maltas) it works very well in a Matrix. This is the calculation:   Ranking Points = VAR Tabla = ADDCOLUMNS(     ALLSELECTED(Transaccione...
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mrbajana ,

     

    I apologize for misunderstanding your point.

    We can create a measure.

    Measure = SUMX(SUMMARIZE('Transacciones',[COD VENDEDORES],"sum ranking",[Ranking Points]),[sum ranking])

     

    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. 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Drag Seller code to the matrix.  Add this measure

Measure = SUM(SUMMARIZE(VALUES(Data[COD VENDEDORES]),Data[COD VENDEDORES],"ABCD",[Ranking Puntos]),[ABCD])

Hope this helps.