Forum Discussion

u92690's avatar
u92690
Frequent Visitor
4 years ago
Solved

Dynamic monthly MAX depending on slicer selection

Hey all,   I'm struggling to find a solution in order to calculate a measure which provide the cusmized Max I need. In particular, I need the monthly max for each Division to show it in a graph, bu...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    u92690 , try a measure like

     

    maxx(values(date[Date]), calculate(sumx(Table, divide([A],[B]))))

u92690's avatar
u92690
Frequent Visitor
4 years ago

Superb! Thanks!