Forum Discussion

ChristianDLS56's avatar
ChristianDLS56
Frequent Visitor
3 years ago
Solved

Maximum Value of a Dynamic Measure

Good day everyone! Would anyone know how to create a measure that returns the maximum value of a dynamic measure?   Example: MARKET SALES UNIT UNIT/SALES A 20 5 4 B 10 2 5 C ...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    ChristianDLS56 ,

    try this measure

     

    Max sales = 
VAR _max = MAXX(ALLSELECTED(Tablename[Market]),[Measure])
RETURN _max

     

    Thanks,

    Arul

  • Ahmedx's avatar
    Ahmedx
    3 years ago

     

    try this measure,
Measure = MAXX(ALLSELECTED('table'[MARKET]),[UNIT/SALES])

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

 

try this measure,
Measure = MAXX(ALLSELECTED('table'[MARKET]),[UNIT/SALES])

 

  • ChristianDLS56's avatar
    ChristianDLS56
    Frequent Visitor
    3 years ago

    This is amazing Ahmedx , you're a lifesaver